retain formats

  1. M

    Retain Pivot Table Formatting

    I've seen many posts about retaining the pivot table formatting when pasting values to unlink it from the source. The paste special values does not work. I've tried using the clipboard to paste and it worked one time. In the same workbook attempting to copy and paste the values and formatting...
    • mha112897
    • Thread
    • paste values and formats pivot 2010 pivot table formatting retain formats
    • Replies: 1
    • Forum: Excel Questions
  2. S

    Need VBA to join cells into one single cell in other column

    Need VBA to join cells in column A and put into one single cell in column B. However, the result in column B needs to retain bold and underlining aspects that exist in some of the data in part of each cell in column A I am currently using the following code which joins the cells ok, however...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top