Paste Special

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and Pasting Formulas are incrementing 3
cannot paste source column width to destination column width 1
Automatically format 2
how to link to external worksheet 5
Changing Of Column Values ? 3
Copying everything 4
Paste Special 1
Paste Special Values 2

Back
Top