ICON Home Page ICON Members' Forums Home Page
Members' Forums
Save Password Forgot your Password?

Home | Profile | Register | Active Topics | Members | Search | FAQ
 All ICON Forums
 Help Forums
 Office Applications
 Printing all of Row 1 at top of each page in Excel
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Working Member

25 Posts

Posted - 12/07/2006 :  03:22:16  Show Profile
I have a spreadsheet with Rows 1 through 120 and Columns A through BD (56 columns). Row 1 actually labels the columns; Columns I through BD are labeled as dates, e.g., 1-Jan., 8-Jan., 15-Jan., etc. I have frozen panes so that the dates in Row 1 always appear on the screen; however, I would like for all of Row 1 to also appear at the top of each printed page. Can that be done, and how?


204 Posts

Posted - 12/07/2006 :  08:10:33  Show Profile
To have Row 1 appear at the top of each page, follow this path: File > Page Setup > Sheet (tab). Click the icon next to "rows to repeat at top", then use your mouse to select the top row. This will fill in the blank with $1:$1. Press "enter", and then click the Print Preview button to make sure it looks as you wish. (You may want to click "next" in Print Preview so you can see a page other than the first one.) You can select multiple rows to repeat if you wish.

Hope this helps,
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
ICON Computer Users Group © Interactive Computer Owners' Network Go To Top Of Page
Snitz Forums 2000