Printing Column Headings

M

Martin

Hi,

How do I go about printing the column headings on each
new page of my spreadsheet?

Thank you
 
M

Martin

Thank you for the reply.

That option is greyed out

How do I make it available

Thanks
 
E

Evie

Go to PAGE SETUP
Click on SHEET Tab
Then, click inside the cell entitled "Rows to Repeat at
Top"
Now, go back into your Worksheet and (Select) the Row (or
Rows) that you want to repeat. Then, click OK.

Easy schmeeezy. You're done. =)

Let me know if you have any trouble with this. I'm happy
to help where I can.

Evie
 
M

Martin

How does one make the option available then or can it not
be enabled?

Martin
-----Original Message-----
Hi Martin,
You can't get to it from print preview, it is also grayed out by grouping sheets.

I have a page on "grayed out" options (greyed out)
http://www.mvps.org/dmcritchie/excel/grayedout.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Martin" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
D

David McRitchie

Hi Martin,
Sorry, about that.
The normal way to get this option is via
File, Page Setup, Sheet
 
M

Martin

Many thanks, I think I have got it worked out.

Martin
-----Original Message-----
Hi Martin,
See my web page
http://www.mvps.org/dmcritchie/excel/freeze.htm

File, Page Setup, Sheet
Rows to Repeat at top: $1:$1
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Martin" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Top