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

[iren]

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

 

[SkipVought]

Hi,

File > Page Setup > Sheet Tab - Print Titles section

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[iren]

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

 

[xlbo]

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

 

[SkipVought]

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,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}