Freezing Rows and Columns

When you have a document that spans multiple pages, you might want your column titles/headers to be repeated on each page.
  1. Click the Page Layout tab
  2. In the Page Setup group, click Print Titles
  3. In the Print Titles section, place your mouse cursor in either the Rows or Columns fields (depending on which you want to repeat when printed)
  4. Click then drag-select the cells that contain the rows or column headers you want to repeat on each page.

Bookmark and Share

Tags: , , , , ,

Leave a Reply

Spam Protection by WP-SpamFree