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?