Pasting formats and values without formulas

R

Rae

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

JoeU2004

Rae said:
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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top