Hi All,
I need a help to count page no a print view. when i goto print to show page page no on cell F4 on print section for same location.
see the file
Thanks
Hi All,
I need a help to count page no a print view. when i goto print to show page page no on cell F4 on print section for same location.
see the file
Thanks
You have to put your page number in a header instead of on the worksheet. Which you have already done, so I don't understand your question.
The correct syntax should be: Page # &[Page] of &[Pages]
You can, using a macro enabled file, get "Page X of Y" to appear in a cell, instead of in a header. BUT.
The method that I know of will NOT work in your case, because the cell you want the value to appear in is the same cell (F4) repeated on every page. It is not F4 on the first page, F74 on the second, F144 on the third, etc.
So the best option for you is to get it working properly in your header. I have attached a file with it working in the Header.
Why are you still using the ancient .xls file extensions when you have either 2013, or 365, or both??? This file is saved as .xlsx.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
If you desire to have the paging inside the Counter Sheet box: put the paging in Center section of the Header and use spaces to push the paging towards right side of page (there is limit to the number of characters you can use), and then increase Header margin.
Thanks josephteh and Glenn,
The Working is perfect josephteh sheet page number inside the sheet. Glenn i am using your sheet but do not show inside the cell page number. see the snap.
josephteh, can you please tell me how to apply it? i am trying but failed to page# at last position.
see the snap.
Thanks
Did you READ what I said:
"The method that I know of will NOT work in your case, because the cell you want the value to appear in is the same cell (F4) repeated on every page. It is not F4 on the first page, F74 on the second, F144 on the third, etc."
Click on Custom Header:
Custom Header.png
Hi josephteh,
i tried but not reach at the end position. please see the file. i use all your setting margin and custom header but failed. can you please set it it my file?
its working but not my desired position.
Thanks.
Hi Glenn,
but how josephteh sheet is working?
Remove fill color at cell F4, add more spaces in header and increase header margin to 3.1:
add more spaces.png
paging inside box.png
Thanks josephteh,
Its Perfect Like Cheer. i see it in someone sheet but dont know how its working but its lovely.
Thanks a lot to define it.
Thanks Glenn.
Thanks.
Your are welcome, majidsiddique! If the issue is solved, please mark the thread "Solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks