Copying worksheets exactly as you've laid them out

[MANNING]

I'm using Excel to produce sales invoices which are printed onto pre-printed invoices, so I have had to alter certain row heights and column widths. When I copy to a new sheet it keeps the formulae but reverts all row heights to the default. How can I prevent this from happening?

 

[sabrefan62]

Instead of copying the information to a new sheet, try copying the entire sheet. Right click on the tab for the worksheet at the bottom of Excel, and select Move or Copy. Select the position in the tabs where you would like the worksheet to go and select Create a Copy. Click OK and it will create a copy of the tab exactly as you have it formatted. You can then rename the tab as you wish.

 

[MANNING]

Thanks for this - this is what I have done for the majority but I wanted to make a continuation sheet on the same worksheet. When I copy it lower down on the page I lose the settings I have made with regard to the row heights. Very frustrating!

 

[sabrefan62]

Have you tried using the format painter?

 

[MANNING]

Have you tried using the format painter?

Yes, that doesn't work either! I am sure it must be possible but I just can't see how!