+ Reply to Thread
Results 1 to 13 of 13

page no show on cell on print view

  1. #1
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    page no show on cell on print view

    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
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: page no show on cell on print view

    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.

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,956

    Re: page no show on cell on print view

    The correct syntax should be: Page # &[Page] of &[Pages]

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: page no show on cell on print view

    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.
    Attached Files Attached Files
    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

  5. #5
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,956

    Re: page no show on cell on print view

    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.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: page no show on cell on print view

    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
    Attached Images Attached Images

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: page no show on cell on print view

    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."

  8. #8
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,956

    Re: page no show on cell on print view

    Click on Custom Header:

    Custom Header.png

  9. #9
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: page no show on cell on print view

    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.
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: page no show on cell on print view

    Hi Glenn,
    but how josephteh sheet is working?

  11. #11
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,956

    Re: page no show on cell on print view

    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
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: page no show on cell on print view

    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.

  13. #13
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,956

    Re: page no show on cell on print view

    Your are welcome, majidsiddique! If the issue is solved, please mark the thread "Solved".

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Page Layout View does not show Row and Column Headings
    By robmbaker in forum Excel General
    Replies: 4
    Last Post: 07-04-2019, 09:16 AM
  2. Replies: 3
    Last Post: 03-17-2019, 05:17 AM
  3. Replies: 0
    Last Post: 05-07-2013, 10:56 AM
  4. How to only the print area in the page layout view?
    By monarchos in forum Excel General
    Replies: 2
    Last Post: 05-24-2012, 05:30 PM
  5. I've lost my page view, only shows in print preview?
    By littlejof in forum Excel General
    Replies: 2
    Last Post: 11-24-2008, 07:06 AM
  6. View /Print selected options contiguously separate page
    By t_track in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-25-2008, 07:26 PM
  7. Page view vs. Print View
    By Mark G in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-24-2005, 04:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1