| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Stop wasting time looking for files and revisions! Dokkio, a new product from the PBworks team, integrates and organizes your Drive, Dropbox, Box, Slack and Gmail files. Sign up for free.

View
 

Excel 2007 tips

Page history last edited by Kathleen Porter 9 years, 11 months ago

 

 

 To make one or more title rows repeat at the top of every page (or make columns repeat on the left, for example)...

  1. Click the "Page Layout" tab.
  2. Click the "Print Titles" icon.
  3. Click your cursor in the "Rows to Repeat at Top" box so that it's blinking there.
  4. On your worksheet, click the rows you want to repeat.
  5. Click "OK".

You can use Print Preview to check that it looks the way you want before you print. That way if you insert or delete lines you don't have to move the title lines -- they'll move automatically.

 

 

Comments (0)

You don't have permission to comment on this page.