Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to add column heading on all pages of the worksheet? 1

Status
Not open for further replies.

iren

Technical User
Mar 8, 2005
106
US
Hi everybody!

How to add column headings on all pages of the worksheet?

I need it to be exactly as on the very first page....

Thank you in advance,

Iren
 





Hi,

File > Page Setup > Sheet Tab - Print Titles section

Skip,

[glasses]Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![tongue]
 
Skip,

Thank you for the responce.

However I am not sure how to handle with the print step.
I assume that it is an option “rows repeat at the top.

However when I am trying to put number 1 into the window (because I need to repeat row #1 as a header on each page), system generates an error, saying “Invalid reference”

What I am doing wrong?

Iren
 
1:1 is the correct way to reference a row

or you could always just click in the "rows to repeat at top" box then select the row in the spreadsheet and excel will insert the reference for you...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 



As a rule, any time you have to enter ROW, COLUMN, CELL or RANGE references into a box or formula, the BEST way, as Geoff has indicated, is FIRST, be sure your cursor position is IN THE BOX or IN THE FORUMLA, and then actually select the ROW, COLUMN, CELL or RANGE, and Excel will put it where your cursor was, with all the necessary syntax.

Skip,

[glasses]Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top