How can formatting (number and font, cell highlighting, size, etc.) and cell
values be pasted without pasting 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?

"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.

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?