Finance | Project Operations, Human Resources, ...

How to get the current page number in electronic reporting?

(0) Share

Report

Posted on by zohaib250

Hi ,

I am new to electronic reporting and working on an excel template where I need to show the current page number in a cell as ( page 1 of 1) as can be seen in the screenshot below .

We can get that in header or footer but as per our requirement we need to display it in one of the cells . Can you please guide me how can i get this value ?

Thanks,

Syed

I have the same question (1)

All responses (5)

Answers (0)

Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report

I'm not an expert either, but from the link it seems you can get it with &P.

docs.microsoft.com/.../er-fillable-excel

Was this reply helpful? Yes No
zohaib250 50 on at

Like (0)

Report

Hi Ergun,

Thanks for your response , I tried this approach but its not working for me . It simply displays this value in the cell ( Page &P of &N ) .

Was this reply helpful? Yes No
Jeb Baker 15 on at

Like (0)

Report

Hi Syed. I don't think it's possible to do in Excel without VBA code. And you can't import an Excel file with macros into Electronic Reporting.

Was this reply helpful? Yes No
Suggested answer

Huggins Mafigu 507 on at

Like (0)

Report

You can achieve this by formatting on Excel document itself I guess. For example, if you are working on a word template you can just insert this. Not quite sure about Excel.

Was this reply helpful? Yes No
MatthewL2000 5 on at

Like (0)

Report

I have gotten the same result. Does anyone know how to get current page number in the enabled forumla in order to suppress certain sections? Thank you!

Was this reply helpful? Yes No