Column headings

by Learner7 Apr 19, 2007 6:36AM PDT

I have been trying to format my Excel worksheet so that the column headings appear on each page but can't find any way to do this. It said I could 'print' them on each page, but when I put the letters of each column in the box it said it was wrong. I don't just want to print them on each page, I want them on each page on the computer.

Discussion is locked

- Collapse -

Re: Excel headings

by Kees Bakker Apr 19, 2007 8:32PM PDT

From the menu bar: Window>Freeze panes. See: http://www.techonthenet.com/excel/questions/freeze2.php

Note the effect depends on which cell you're in when you do this. I'll leave it to you to find out the details.

Kees

- Collapse -

Freeze panes

by Learner7 Apr 20, 2007 12:32AM PDT

This worked on computer screen, and I can see the headings all the way down, but it does not print out. I tried going into Page set up and 'Sheet' but don't know how to make it print the headings on each sheet.

- Collapse -

Re: print top lines on each page.

by Kees Bakker Apr 20, 2007 6:17AM PDT

On the Sheet tab of File>Page setup (you're on track) fill in $1:$1 if you want the first row to appear as the top row on each printed page. And $1:$2 if you want the first 2 rows printed as the top rows on each printed page.

Hope this helps.

Kees

- Collapse -

Printing headings

by Learner7 Apr 21, 2007 3:54AM PDT

THANK YOU SO MUCH! If only Microsoft would explain how to fill in the boxes, I tried everything but never thought of using a dollar sign. I am most grateful.

Column headings

CNET Forums

Other Forums

Forum Info