Sunday, September 16, 2012

Is it possible to copy Page Setup?


Many of us would have faced this situation - where we take a lot of time to do some specific page setups for a worksheet, and later realise that we did not select the other sheets while doing the setup.

The result? - you would have to do the whole thing all over again, because Excel does not offer a regular menu option to copy the page setup features. We have all sorts of copy-paste, including format painters but when it comes to Page Setup, none of those come to the rescue.

Never mind, trust the experts to always come up with an easy solution. Here we have a simple solution for this complex problem - one of the most appreciated tips from my book "Excel for the CEO".

Problem Statement:

Apply the specific page setup settings for one worksheet to the eight other worksheets in the same workbook.

There is no built-in option to do this in Excel.

Solution steps:

  1. What you need to do is very simple – first place your cursor in the sheet that has the page setup you want to use.
  2. Now select the sheets where you want to apply the page setup using the mouse cursor while holding down the Ctrl key. 
  3. If you are using Excel 2003, select File → Page Setup from the Main menu and just click on OK. 
  4. In Excel 2007 & later, Page Setup is available from the Page Layout tab of the Ribbon. Alternate is to select File->Print and then click on the small Page Setup button available under this. 
  5. That’s all – your page settings are automatically transferred to the eight new sheets.



Note: Some of the tips shown here are extracts from my book on "Excel for the CEO" - details available at www.mrexcel.com/ceo.shtml. You can also find this in the ebook edition "Excel for the Small Business Owner" available for online ordering at www.mrexcel.com/sbo.shtml

1 comment:

Unknown said...

I just faced this situation, and your tip on page setup was a blessing. Saved me a lot of time as I otherwise would have done it all over again for each sheet.

Thanks a ton!