Retaining identical format/look after copy paste

J

Jim May

On my Sheet1 I have a highly custom financial statement
with fonts, bold, underlines, several column widths set to 2
versus std 8.43
So when I highlight and copy it, say with the range B2:M50
to sheet2 D4
how can I retain the identical "look" on sheet2 as is on sheet1?

Can this be done using the Copy/Paste or Copy Paste-Special
route? I prefer not going to the right-click on tab and the create
copy of worksheet approach.
TIA
 
D

Dave Peterson

In xl2k and higher, you can copy|paste special and choose to copy column widths.


In all versions, if you copy the whole column, the column widths will come along
for the ride when you paste.
 
Top