How to insert footpage number in a cell

  • Thread starter Thread starter bren
  • Start date Start date
B

bren

Hi,

I would like to know if it´s possible to insert in a cell the page
number of each page. Example

In cell D4 says "Page 1 of 3"
In cell F51 "Page 2 of 3"
In cell F98 "Page 3 of 3"

Nad so on...

Thank you so much
 
bren said:
Hi,

I would like to know if it´s possible to insert in a cell the page
number of each page. Example

In cell D4 says "Page 1 of 3"
Click to expand...

F4? footpage? i guess you mean head
In cell F51 "Page 2 of 3"
In cell F98 "Page 3 of 3"
Click to expand...


Since you want to do it manually:

F4: ="Page "&(ROW()-4/47)+1&" of "&INT(ROWS(A4:A143)/47)+1

or similarly.

Consider Header/Footer instead, which does it automatically for you.
 
bren said:
Thank you so much! And how can I do it automatically?
Click to expand...

I guess it using the menu entries of my German version:

Print Layout Setup_Page Header/Footer Userdefined_Header/Footer

There you select two icons
&[Page]&[Pages]

and change it to
Page &[Page] of &[Pages]
 
Back
Top