+ Reply to Thread
Results 1 to 7 of 7

Showing current page number and total page number in entire workbook?

  1. #1
    Registered User
    Join Date
    11-14-2013
    Location
    canada
    MS-Off Ver
    Excel 2103
    Posts
    3

    Showing current page number and total page number in entire workbook?

    In my header I am trying to show the current page number and the total number of pages in the workbook. So if I have 10 pages in my workbook, page 5 would read "5 of 10".

    I have this in my header "&[Page] of &[Pages]". All worksheets with 1 page read "1 of 1" and worksheets with 2 pages read "1 of 2" on the first page and "2 of 2" on the second page.

    If anyone could help me out that would be awesome!

    Thanks in advance.

  2. #2
    Registered User
    Join Date
    11-14-2013
    Location
    canada
    MS-Off Ver
    Excel 2103
    Posts
    3

    Re: Showing current page number and total page number in entire workbook?

    Any ideas? Is "&[Page] of &[Pages]" only displaying the page numbers for a worksheet, not a workbook?

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,183

    Re: Showing current page number and total page number in entire workbook?

    I have this in my header "&[Page] of &[Pages]". All worksheets with 1 page read "1 of 1" and worksheets with 2 pages read "1 of 2" on the first page and "2 of 2" on the second page
    What is wrong with this?
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    11-14-2013
    Location
    canada
    MS-Off Ver
    Excel 2103
    Posts
    3

    Re: Showing current page number and total page number in entire workbook?

    I have 10 worksheets. On worksheet 5 for example, I want it to say "5 of 10". Right now it is displaying "1 of 1".

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,183

    Re: Showing current page number and total page number in entire workbook?

    A Workbook can have several worksheets
    Each work sheet can have several pages
    So 'page' is not the same as 'worksheet'

    I think you need VBA for this
    Thereby I can't help you

  6. #6
    Registered User
    Join Date
    02-11-2013
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Showing current page number and total page number in entire workbook?

    Rename your worksheets as chapters and include the name at the header. You wont get a count of the total number of pages but at least you can get a sequence to follow throughout your printed dodument.
    Javier Roques

  7. #7
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Showing current page number and total page number in entire workbook?

    You will probably have several pages on each tab and each tab has its own header. If you print the whole workbook each tab will start on page 1
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Replies: 1
    Last Post: 01-28-2013, 02:14 AM
  2. Replies: 0
    Last Post: 11-08-2007, 09:58 AM
  3. Format page number in excel footer to start at a specific page #
    By straitctrydncr in forum Excel General
    Replies: 3
    Last Post: 04-11-2006, 08:00 AM
  4. [SOLVED] How to display current page number in any cell of that page.
    By Laljeet in forum Excel General
    Replies: 4
    Last Post: 01-25-2006, 03:55 PM
  5. [SOLVED] add page number to entire workseet
    By Charles in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-09-2005, 04:15 PM

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