| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy column, paste special formulas & number formats doesn't work
In Excel 2003 I used to be able to copy a column, then use the paste special
feature to paste the formulas and number formats into a new column. Several months ago (maybe when we did an update?) this feature suddenly stopped working. Instead the formulas and number formats are updated to the new column, but it also copies the values that were in the original column and pastes them into the new column, too. I now have Excel 2007, but it does the same thing. Does anyone know what changed? The instructions for using the program seem to be the same. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste special from cells without formulas/formats | Excel Worksheet Functions | |||
| Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
| how to copy a pivot table and "paste special" formats in excel 07 | Excel Discussion (Misc queries) | |||
| How to copy formulas to a new workbook? Paste Special is different | Excel Worksheet Functions | |||
| Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) | |||
Threaded Mode
