Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Paste Special
Is there any way to paste more than one attribute at a time e.g. Column
width, formats and formulas & number formats rather than having to doing a 'Paste Special' for each attribute? |
#2
|
|||
|
|||
Good question!
I think there is no natural way in Excel. However, there are "Excel add-ins" out there that expand Excel's capability and will offer you options such as "paste numbers and formats" etc. My suggestion is to record a macro (Tools Macros Record New Macro) whilst doing a paste operation of your choice. and then assign the macro to a custom button on your toolbar and simply click it when you are ready to paste. Regards Green "BJS" wrote: Is there any way to paste more than one attribute at a time e.g. Column width, formats and formulas & number formats rather than having to doing a 'Paste Special' for each attribute? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
"paste special" "paste link" | Excel Discussion (Misc queries) | |||
paste special (values) | Excel Worksheet Functions | |||
Paste Special Question | Excel Discussion (Misc queries) |