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

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.

"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

.

Have you tried a right click on the sheet tabmove or copycopy

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
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

Thanks, & Deep Respect

K

"RonaldoOneNil" wrote in message
...
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.

"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

.

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

.