Jan's Working with Numbers

Step-by-Step: Print Options

Start with: , trips9-Lastname-Firstname.xlsx (saved in previous lesson)

Print: Grid lines, Headings, Centered

1. Make Sheet1 active, if necessary, by clicking on its tab.
2. Open Page Setup and make some choices.
   Page Layout tab > Page Setup dialog box launcher
3. On the Sheet tab, in the Print section, check Grid lines and Row and column headings.
    
4. On the Margins tab, in the Center on page section check both Horizontally and Vertically.
   

   

5. Click OK to close the dialog.
6. Open Print Preview and check the new layout.
7. Print.
   

Print: Break Pages, Print Titles

1. From the View ribbon tab, click on the Page Break Preview button.
2. Click on the row heading for Row 26, the blank row between the two tables.
   The row is selected.
    
3. Right click on the selection.
   The context menu appears.
4. Click on 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. That text will not print.
    
   

5. Open Page Setup again to the Sheet tab.
   

6. In the Print Titles box, type in  $1:$2  so that the first two rows will print on all pages.

   Alternate Method: Click in the box and then drag on the spreadsheet to select these rows.

7. Click on the Print Preview button in this dialog.
   

   How does Print Preview show you that two pages will print?

   • Excel 2007: Next Page button on the ribbon.
   • The Status bar shows 1 of 2.
   • The scrollbar length shows there must be another page.

   

8. Use the method of your choice to show the preview of the second page.

   Rows 1 and 2 (the titles) show above what was after the page break. Neat!
   

9. Print.
    

Print: Selection

1. In Normal view select cells A1:E10.
   This is the information about 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 Grid lines and Row and column headings.
4. Click on OK to close Page Setup.
5. Open Print Preview.
6. Edit options:
   Excel 2007: Click the Print button on the ribbon to open the Print dialog. Click on Selection in the dialog.
   
   Excel 2010, 2013, 2016: Under Settings, drop the list and change Print Active Sheets to Print Selection.
   
   
   
7. Print.
   You do not need to save again unless you want to save the Page Setup settings.
    

Show Formulas and Print on One Page

Sometimes you want to see those formulas on paper. It can be easier to track down a strange error this way. You make the formulas show with a key combo but you must look at the Print Preview carefully to see what orientation or other features might need to be changed.

1. In Normal view, hold the CTRL key down and press the ` key, which is usually to the left of the number 1 on an English keyboard. This is the grave accent.
   The columns expand to show their full contents, including formulas.

   

2. On the Page Layout tab open Page Setup with the dialog box launcher. 
3. On the Page tab, select Landscape orientation and Fit to 1 page wide by 1 page tall.
4. If necesssary, on the Margins tab, clear the check boxes for Horizontal and Vertical centering.
   
5. If necesssary, on the Sheet tab clear the check boxes.
   
6. Click the Print Preview button in the dialog.
   Verify that all is correct.

7. Change the print choice to:

   Excel 2007: Active sheet(s)
   Excel 2010, 2013, 2016: Print Active Sheet
8. Print.
   

9. Close the workbook without saving these printing changes.