Excel Basics:
Setup the Page

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web

The way your spreadsheet fits onto paper can be controlled from the Page Setup dialog. You can select the size and orientation of the paper, the width of margins, what goes in the header and footer of each page, and the order of printing cells for sheets that will take several pieces of paper. All in all, there are a LOT of choices. There are so many choices that we will use a separate web page for each tab in the dialog.

Dialog: Page Setup,Page tab

Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel Basics  
Getting Started Arrow to subtopics
      Icon - FootprintRegional Settings
      Icon - FootprintAppearance
      Icon - FootprintPage
      Icon - FootprintMargins
      Icon - FootprintHeader/Footer
      Icon - FootprintSheet
      Icon - FootprintOptions
      Icon - FootprintEnter/Edit/Clear Popup Table
    ArrangeTo subtopics
    AutoFillTo subtopics
    FinishTo subtopics
    ExercisesTo subtopics

Project 3: Format & ArrangeTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics


Icon Step-by-Step 

Step-by-Step: Setup the Page

 Icon Step-by-Step

What you will learn:

to set -
     page orientation
     paper size

Start with: Budget.xls (budget.xls from the resource files)

Page Setup: Page

  1. Open budget.xls
  2. Open  File  |  Page Setup  and click on the Page tab, if necessary.

    The default settings are shown in the illustration.

    Orientation = Portrait; Scaling = 100%; Paper size = Letter

    Print quality = 300 dpi; First page number = Auto

    Dialog: Page Setup, Page tab

    Landscape orientation is often used with spreadsheets since you can show more columns. Your Print quality default setting may be different. It depends on your printer. Outside the USA, the default paper size is probably A4.

  3. Statusbar message: Preview: Page 1 of 2Click on Text Button: Print Preview the Print Preview button. How many pages will it take to print this sheet? Look at the Status bar Message Area.

    Print Preview- page 1Print Preview- page 2
    In Portrait orientation it takes two pages to print. 
    The second page does not show the titles or the row labels.

  4. Click on Text Button: Setup the Setup... button on the toolbar to go back to the dialog. 

  5. In the Page Setup dialog, change the orientation to Landscape.

  6. Click on Text Button: Print Preview again. If there is no Print Preview button, click on OK and you will go back to Print Preview. 
    How many pages will it take to print this sheet? Which orientation is a better choice for this sheet, assuming you make no other changes?

    Preview in landscapte  = 4 pages
    In Landscape orientation the same sheet takes 4 pages to print.

  7. Return to the Page Setup dialog by clicking Text Button: Setup the Setup button. Leave the sheet in Landscape orientation.
  8. Look at the Scaling section. You can reduce the size of your document on the page by a percentage or you can make it fit into a certain number of pages. Excel's Fit to feature is more flexible than Word's Shrink to Fit, which can only reduce the document length by one page
  9. In the Scaling section, select Fit to: 1 page(s) wide by 1 tall.

  10. Click on Text Button: Print Preview the Print Preview button. If there is no Print Preview button, click on OK and you will go back to Print Preview.  Your sheet now fits onto one piece of paper. All the fonts were reduced in size. Can you still read the data easily?

    Budget in landscape after Fit to: 1 page wide by 1 page tall

    TipFit to is most helpful when your data is just a column or two too wide or a row or two too tall. Things get too tiny if there is a lot of data to shrink down to one page.

    Warning If you change the Scaling from 100% or use the Fit to setting, your previous page breaks are ignored. To get the page breaks back, you will have to open the Page Break Preview again and make changes.

    TipThe Options button in the Page Setup opens the Printer Options dialog and not Excel's Options dialog. Options, options, options! Anyone need more options??

  11. Close budget.xls without saving your changes.

LessonsWorking with Numbers Previous Page Next Page

Teachers: Request permission to use this site with your class

Copyright © 1997-2012 Jan Smith   <jegs1@jegsworks.com>
All Rights Reserved

Icon: DonwloadIcon: CDWant a local copy with no ads? - Download/CD
Want to help?

~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~

Last updated: 02 May 2012