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

  • Social distancing? Try a better way to work remotely on your online files. Dokkio, a new product from PBworks, can help your team find, organize, and collaborate on your Drive, Gmail, Dropbox, Box, and Slack files. Sign up for free.

View
 

Excel 2007 tips

Page history last edited by Kathleen Porter 10 years, 1 month 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.