Page Number in Excel 2000

[TheRealDeal]

Is it possible to make the Page No and NoOfPages appear in a cell that is part of the header? For example, if I have 5 lines that repeat as the header with every page, how would I get the page numbering scheme to appear in a particular cell?

 

[AnotherHiggins]

I would advise designing your sheet in such a way that you have an ACTUAL header (File > Page Setup > Header/Footer > Custom Header) that lines up with what is in the first five rows.

This can be accomplished by adjusting overlapping margins (i.e. header margin 1", top margin 0.5").

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

Hi,

View/Page Break Preview...

will display the page breaks visibly.

Skip,

_[red][/red]

 

[AnotherHiggins]

If I understand the OP, the request is to have the number of the page currently being printed appear somewhere within the first five rows (which is being repeated at the top of each page as a header).

TheRealDeal - Perhaps I should have been more explicit in my earlier reply: No. You can't do that.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.