If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pasting formats and values without formulas
How can formatting (number and font, cell highlighting, size, etc.) and cell
values be pasted without pasting formulas? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|