Pasting formats and values without formulas
 

How can formatting (number and font, cell highlighting, size, etc.) and cell
values be pasted without pasting formulas?

Pasting formats and values without formulas
 

hi
on the 2003 menubar
editpastespecialformats

regards
FSt1

"Rae" wrote:

How can formatting (number and font, cell highlighting, size, etc.) and cell
values be pasted without pasting formulas?

Pasting formats and values without formulas
 

"Rae" wrote:
How can formatting (number and font, cell highlighting, size, etc.) and
cell
values be pasted without pasting formulas?

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.

Pasting formats and values without formulas
 

Two steps?

Paste SpecialValues

Paste SpecialFormats.

Or one step if using the Show Paste Options buttonValues and source
formatting.



Gord Dibben MS Excel MVP

On Fri, 19 Jun 2009 13:38:01 -0700, Rae
wrote:

How can formatting (number and font, cell highlighting, size, etc.) and cell
values be pasted without pasting formulas?