How to Insert Page Numbers in Microsoft Excel 2010

You can insert page numbers so that you can print them on every page in Microsoft Excel 2010.

Let’s take an example and understand how you can insert page numbers in a workbook..

We have data in the range A1:F113. We need to take a printout of this sheet. Every sheet has a limit on the number of rows which will be visible on the printed output, after which the data would be printed on the next page. To take the printed output and put it in sequence we use the “Page Setup” option. Usually this option is used for printing books or large files

 

To insert page numbers in Microsoft Excel follow the below mentioned steps:-

    • Go to the “Page Layout” tab.
    • In the “Page Setup” group click on the dialog box launcher in the bottom right corner.

 

img1

 

    • The Page Setup dialog box will appear.

 

img2

 

    • Select the “Header/Footer” tab.
    • In Header or footer drop down menu, few preset options areavailable.You can set Header / Footer to “page 1” or “Page 1 of?where the ? is for the total number of pages.

 

img3

 

    • If you need more customized Header/Footers…. Click Custom Header/ Custom Footer.
    • In the dialog box which opens….you will find 3 sections.
      a) Left Section
      b) Right Section &
      c) Center Section
    • In each section you can add
      a) Text
      b) Some predefined data like page number, time, date or file name by clickingon thebuttons provided.
      c) You can add picture/ Company logo also.

 

img4

 

  • After finishing all the steps click on ok.
  • When you will take the printout you will get the printed output with the page numbers.

Leave a Reply

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

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>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube