Copying everything

[KRK]

hello,

I have a large (26 * 750 cells) complex sheet which I want to copy to
another sheet in the same workbook. I want to copy everything, formats,
values, formulae, fonts, and column & row widths and heights.

I know how to copy & paste everything except the row & column widths &
heights. Is there a shortcut way of doing this ?

Thanks

K

 

[RonaldoOneNil]

Click the grey blank square to the left of column A and just above row 1.
Click copy, go to your other sheets and either clcik the gery square or cell
A1 and click paste.

 

[Don Guillett]

Have you tried a right click on the sheet tab>move or copy>copy

 

[KRK]

Thanks, & Deep Respect

K

Click the grey blank square to the left of column A and just above row 1.
Click copy, go to your other sheets and either clcik the gery square or
cell
A1 and click paste.

 

[MJ]

Here's an easy way to copy an entire spreadsheet including formulas, formats,
etc. Hold down the control key and click on the spreadsheet you want to cop
and drag to the right. You will see a slight indicator with a plus...release
the mouse...you now have a duplicted worksheet. this is much esier than
copying and pasting.

MJ