Displaying header row

amcrowe · May 10th, 2002, 08:53 AM

Sounds simple, but how do I display a row of column headers all the time I scroll down and examine rows too far down for the header row to "normally" be displayed?

There is a way to print each new page with the column headers, but I need it for screen display.

Brian from Maui · May 10th, 2002, 09:03 AM

If your header row ts in A1:G1 for example, click on B1 go to Windows/Freeze Pane

Corni · Jun 1st, 2002, 05:27 PM

If you need to print the column header for each page you print, you have to set up page:

File/Page Setup/Sheet tab/Select Rows to repeat at top.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 08:53 AM	#1
amcrowe New Member Join Date: May 2002 Location: Akron, OHIO, USA Posts: 6	Sounds simple, but how do I display a row of column headers all the time I scroll down and examine rows too far down for the header row to "normally" be displayed? There is a way to print each new page with the column headers, but I need it for screen display.

May 10th, 2002, 09:03 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	If your header row ts in A1:G1 for example, click on B1 go to Windows/Freeze Pane

Jun 1st, 2002, 05:27 PM	#3
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	If you need to print the column header for each page you print, you have to set up page: File/Page Setup/Sheet tab/Select Rows to repeat at top.