How to insert footpage number in a cell

[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

 

[Alexander Wolff]

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"

F4? footpage? i guess you mean head

In cell F51 "Page 2 of 3"
In cell F98 "Page 3 of 3"

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]

Thank you so much! And how can I do it automatically?

 

[Alexander Wolff]

Thank you so much! And how can I do it automatically?

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]