Notifications
Announcements
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'm not an expert either, but from the link it seems you can get it with &P.
docs.microsoft.com/.../er-fillable-excel
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 ) .
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.
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.
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!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 663 Super User 2026 Season 1
Abhilash Warrier 289 Super User 2026 Season 1
Martin Dráb 232 Most Valuable Professional
