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? |
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? |
All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com