Pasting formats and values without formulas

  • Thread starter Thread starter Rae
  • Start date Start date
R

Rae

How can formatting (number and font, cell highlighting, size, etc.) and cell
values be pasted without pasting formulas?
 
Rae said:
How can formatting (number and font, cell highlighting, size, etc.) and
cell
values be pasted without pasting formulas?
Click to expand...

In Excel 2003, not in a single copy-and-paste operation.

With copy-and-paste-special, you can paste "value and number formats".

But that does not do font, column/row size, pattern, border, and alignment.

To do it all manually, you have to do copy, then do successive paste-special
operations selecting values, formats, comments and column widths. I don't
know of any operation that copies row height.

Alternatively, you could create a macro. Do it once with Record Macro, then
customize for your purposes.
 
Two steps?

Paste Special>Values

Paste Special>Formats.

Or one step if using the Show Paste Options button>Values and source
formatting.



Gord Dibben MS Excel MVP
 
Back
Top