Page Number

  • Thread starter Thread starter Leif
  • Start date Start date
L

Leif

Hi,
In Excel 2000, is there a formula to make a cell contain page number and
total number of pages?

We want to have a heading with our logotype and other information and as
Excel 2000 can not include pictures in heading we want it on top of every
sheet. I can make Excel print rows on top, but can I include page number and
total number of pages in the sheet?

Thanks in advance

Leif
 
I'd use an actual header (or footer).

File|Page Setup|Header/Footer Tab

Click on Custom header (or footer)

You see a couple of icons that look like a sheet of paper.

the icon with # in it is Page#. The icon with ++ in it is #pages.
 
Hi Dave
Yes. I know how to get date in header/footer, my question, however was if I
can get page numbers in a cell as I cannot get a picture in headings in
Excel 2000.
 
Thanks a lot!



David McRitchie said:
Hi Leif,
You need program code to do that.

Page number of the active cell, Find the page number of the activecell
Click to expand...
(Sub not formula). Laurent Longre 2000-04-21
 
Back
Top