Inserting Page Numbers in Excel 2007





Inserting Page Numbers in Excel 2007

Excel offers a number of options for printing continuous page numbers.

To Insert a Page Number using Page Setup dialog box:

  1. Select Page Layout -> Page Setup Group > Click Dialog Box Launcher in the bottom-right corner
  2. grooup
  3. It will open Page Setup Dialog Box for you.
  4. grooup
  5. In Page Setup Dialog Box > Select Header / Footer Tab.
  6. grooup
    1. In Header or Footer Dropdown menu, few preset option available to set. You can Set Header / Footer to “page 1” or “Page 1 of ?”.. for example..
      1. Page 25
      2. Page 25 of 60
    2. If you need more customized Header / Footer.. click Custom Header / Custom Footer.
      1. In opened Dialog Box… you will find 3 section
        1.                                                                i.      Left
        2.                                                              ii.      Center &
        3.                                                             iii.      Right
      2. In each section you can add
        1.                                                                i.      Text
        2.                                                              ii.      Some predefined Data like page Number, Time, Date or File Name, by using clicking buttons.
        3.                                                             iii.      You can add Picture / company Logo also.

Arlette Aloysius

Arlette Aloysius has more than 10 years of experience working with excel. She started teaching excel and other microsoft office programs to government employees when she was in college as part of extra-curricular activities. In her 9 years of work experience, she has worked extensively on excel and automated several reports using vba. In her current role as administrator of Excelforum.com, she provides simple as well as complicated vba solutions to users who need their reports to be automated. She is a Commerce graduate who specialized in Computer Applications where she was able to pick up the basics of the VB programming language. She then pursued to do her Post Graduate Diploma in International Business. Excel sheets are part of her daily life. She uses it even for small personal uses like keeping track of household expenses, investments, etc. By using excel as a tracker cum dashboard helps her to be up-to-date with all financial aspects in her day to day operations.



2 thoughts on “Inserting Page Numbers in Excel 2007

Leave a Reply

Your email address will not be published. Required fields are marked *


2 × six =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>