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.