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.
- Click
the Page Layout tab
- In the Page Setup group, click Print Titles
- 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)
- Click then drag-select the cells that contain the rows or column
headers you want to repeat on each page.
|
|
Excel Navigation and Views are covered in these
Excel classes:
See our other Excel topics.
Tags: Columns, Excel 2007, Freezing, Microsoft Excel, Rows, Training
This entry was posted
on Monday, April 13th, 2009 at 1:50 pm and is filed under Microsoft Excel.
You can follow any responses to this entry through the RSS 2.0 feed.
You can skip to the end and leave a response. Pinging is currently not allowed.