| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| values v formulas with conditional formats | Excel Discussion (Misc queries) | |||
| Using VB Copy Entire Row but formulas and formats only no values | Excel Discussion (Misc queries) | |||
| Excel is pasting values, not formulas by default | Excel Discussion (Misc queries) | |||
| Bug? Pasting values instead of formulas... | Excel Discussion (Misc queries) | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
Hybrid Mode
