Excel Basics:
Print Options

Step-by-Step: Print Options

---

What you will learn:

to print gridlines and headings to center sheet on page to change page breaks to print titles to print selection

---

Start with: , trips9.xls (saved in previous lesson)

Print: Gridlines, Headings, Centered

1. Make Sheet1 active, if necessary, by clicking on its tab.
    
2. Open Page Setup (File | Page Setup....) and make some choices.
    

3. On the Sheet tab, in the Print section, check Gridlines and Row and column headings.
    
4. On the Margins tab, in the Center on page section check both Horizontally and Vertically.
   
    
5. Click on OK to close Page Setup.
    
6. Click on the Print Preview button to check layout.
    
7. Print.
   
   

---

Print: Break Pages, Print Titles

1. From the menu choose  View  |  Page Break Preview .
    
2. Right click on the row heading for Row 26, the blank row between the two tables.
    
3. From the popup menu select  Insert Page Break .
   

   A new blue line appears at the top edge of Row 26. The sheet is now divided into two parts, which will print separately. Note the gray Page 1 and Page 2 in the center of each part.
   
   

    
4. Open Page Setup again to the Sheet tab. ( File  |  Page Setup... ).
    
5. In the Print Titles box, type in  $1:$2  so that the first two rows will print on all pages. (You can also click in the box and then drag on the spreadsheet to select these rows.)
    
6. Click on the Print Preview button in this dialog.
   

   The Print Preview window shows that there are two pages to print by: 

   • There is a Next button at the top.
   • The Status bar shows 1 of 2.
   • The scrollbar length shows there must be another page.

   
    

7. Click on the Next button to see the second page. Rows 1 and 2 (the titles) print above what was after the page break. Neat!
    
8. Print.

   
   

---

Print: Selection

1. In Normal view select cells A1:E10. (This is the information on just the Tahiti trips.)
    
2. Open Page Setup to the Margins tab. Uncheck the two boxes for Center on page.
    
3. Click on the Sheet tab. Uncheck the two boxes for Gridlines and Row and column headings.
    
4. Click on OK to close Page Setup.
    
5. From the menu select  File  |  Print...  to open the Print dialog.
    
6. Check Selection.
    
   
7. Click on the Preview button on the dialog box to open Print Preview.
   
8. Print and close the workbook.
   You do not need to save again unless you want to save the Page Setup settings.