Many a times, I adjust the Excel’s
page setup default values for borders, header & footer to suit my printing
needs. However if I add a new sheet to the workbook, Excel default page setup options
will be set for that sheet. I have to change the settings of new sheet to suit my needs. This process repeats for each sheet I add. So, if I want to apply the same page setup to new
sheet or few other sheets in the same file, how to quickly do this? You can achieve this by following the steps below.
Select the sheet where you
already have your page setup values changed, then press down Ctrl key, click
all the other sheets you want this setup to be applied.
In Excel 2007 or later
Click on Page Layout tab > Page
setup group > Click on the small arrow that is at the right bottom of
the group, this arrow will be under Print
Titles button.
If you are using Excel 2010, you
can also click on File tab > Print > Page Setup
When the Page Setup dialogue box opens up, just click OK. This applies the first selected sheet’s options to all the Ctrl clicked sheets.
When the Page Setup dialogue box opens up, just click OK. This applies the first selected sheet’s options to all the Ctrl clicked sheets.
Excel 2003 or earlier
File menu > Page Setup
When the Page Setup dialogue box opens up, just click OK. This applies the
first selected sheet’s options to all the Ctrl clicked sheets.
