paste value, format, column width at once

[yky]

Can I paste value, format, and column width all at once? Now, I do it in three steps. It'd would save me some time if I can do it in one step.

Also, in VBA, I can paste three times to achieve the effect I want. Can I do it with one paste command?

 

[Trevor G]

Using normal tools you can not paste values, format and change column widths in one go.

Using VBA you would have to do this in steps as well but you can speed this up by switching updating and any calculation commands at run time.

Which cells to copy the values from
Which Columns to go into
Which Formats do you want to apply
And is it AutoFormat or a specific width.