View Single Post
 
Old 02-21-2014, 12:09 AM
jamesdann jamesdann is offline Windows 7 32bit Office 2010 32bit
Banned
 
Join Date: Jan 2014
Posts: 26
jamesdann is on a distinguished road
Default

Follow these steps to do your task.
  1. Open your first worksheet that you have changed the print setup.
  2. Select all worksheets now- You can select all worksheet in two ways.
    • Hold down the Ctrl key and click on all other sheet.
    • Or just do right click on first worksheet and click on Select All Sheets.
  3. Click on Page Layout tab on the Ribbon and find the Page Setup dialogue box. You can see it by clicking at the bottom of right side in the Page Layout section.
  4. Now click on OK in the Page Setup dialogue box.
Reply With Quote