+ Reply to Thread
Results 1 to 8 of 8

number pages in the corner

  1. #1
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    863

    Arrow number pages in the corner

    Hello friends!

    Is there a way to number the pages in the corner like in a book? I mean odd pages in the right footer and for even pages on the left footer, w/o using VBA ?

    Thank you!

    This question has been asked here also : http://www.mrexcel.com/forum/excel-q...ven-pages.html
    Last edited by bulina2k; 01-18-2016 at 06:29 PM. Reason: trackback
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: number pages in the corner

    Go to insert Tab click header footer option there you will find custom header and custom footer tab
    at the top after clicking custom header it will ask you for odd page header or a even page header and similar for footer also
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

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

    Re: number pages in the corner

    Use footer for this
    Under Option you can change odd and even pages

    1 minute to late
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: number pages in the corner

    Have you tried a google search?
    THis was 1 site?
    https://support.office.com/en-us/art...7-bf957c6ce29c
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    863

    Re: number pages in the corner

    Quote Originally Posted by hemesh View Post
    Go to insert Tab ...
    Insert Tab??
    Anyway I know how to insert header and footer, through View - Header and Footer. Then I click on Custom Footer but it doesn't ask me for odd/even pages... What am I missing? The server that I'm working on has a Office 2003 SP3.


    headerfooter.jpg

  6. #6
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    863

    Re: number pages in the corner

    Quote Originally Posted by FDibbins View Post
    Have you tried a google search?
    THis was 1 site?
    https://support.office.com/en-us/art...7-bf957c6ce29c
    Thank you Ford but that particular site doesn't help.


    Oh, and yes I did searched google and excelforum before opening the new thread.

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

    Re: number pages in the corner

    Which version do you work with
    Your profile say 2010 the picture is from 2003?

  8. #8
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    863

    Re: number pages in the corner

    For this matter I'm not working at my computer. It is on some old server...

+ 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. [SOLVED] Macro to number pages
    By HDMI in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2013, 03:24 PM
  2. How to determine Number of Pages of PDF?
    By Konsti1989 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-06-2013, 10:59 PM
  3. Get number of pages of a different sheet
    By drewbagel423 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-03-2008, 02:46 PM
  4. RE: insert 2 colours in a single cell,corner to corner
    By Toppers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-23-2006, 03:50 AM
  5. Count number of pages
    By rm81 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2006, 12:55 PM
  6. Replies: 0
    Last Post: 02-15-2006, 08:35 PM
  7. [SOLVED] Number of pages
    By Pat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-31-2006, 10:15 AM
  8. [SOLVED] How do i number pages in a header consequently
    By JRD in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-23-2005, 02:06 PM

Tags for this Thread

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