1-866-245-5224 sales@keystonelearning.com

Excel 2003: Adding Print Titles and a Print Area

Excel 2003: Adding Print Titles and a Print Area

Print Titles are rows or columns that repeat on every page.

     
  1. Click File on the Menu bar
     
  2.  
  3. Choose Page Setup…
     
  4.  
  5. Click the Sheet tab
     

Figure 22. Page Setup Dialog Box - Sheet Tab

     
  1. Click inside the box next to Rows to repeat at top (or Columns to repeat at left)
     
  2.  
  3. Using the mouse, highlight the chosen rows (or columns) on the worksheet behind the dialog box
     
  4.  
  5. Click OK
     

 

The Print Area is the specific worksheet range that you actually want printed. While you can use the Page Setup Dialog box to set the Print Area, there is a slightly faster way.

     
  1. Select the range of cells you want to print
     
  2.  
  3. Click File on the Menu bar
     
  4.  
  5. Choose Print Area: Set Print Area
     

You can remove a set print area from any worksheet by choosing File: Print Area: Clear Print Area from the Menu bar.