Page Number in cell that updates upon printing

[Pitbull999]

Hi Guys,

Is there a way to put a page number in a cell that updates upon printing?

This is my first post, so apologize that I couldn't attach a picture.


Below is the background situation:

I set Row 1-5 as to repeat on every page.

However, I would like to set Cell F2 to contain my Page number, and update on each page upon printing. Is there a way to do this?

Thank you.

[avk]

Go to "Print Titles" tab > Header & Footer tab > Select Page 1 of > Click on Custom Header > Select Left or Center or Right & mention "Page &[Page] of &[Pages]" > Ok > Ok

[Pitbull999]

Hi avk,

Thanks for replying. The method you mentioned is for putting page number on a header. I want it inside my cell instead.