Thread: Copying everything

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...

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...

Have you tried a right click on the sheet tab>move or copy>copy -- Don Guillett Microsoft MVP Excel SalesAid Software

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...