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

"KRK" wrote:

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

.