sponsored ads

How to Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010

Topic:  Microsoft Office, Excel, Office  Product:  Microsoft Excel , Microsoft Office  Related Articles:  c# multiple datagridviews multiple worksheets   2012 calender multiple worksheets   insert page ireport  

Do you know you can get page numbers in Microsoft Excel as in Microsoft Word? Especially, when you print a worksheet , you may want number pages . You can insert page numbers in the headers or footers of the worksheet pages. Take Microsoft Excel 2010 for example. Then I will introduce how to insert page numbers on a single or multiple worksheets.

sponsored ads

Solution

  1. Open the Excel document which you want to add page numbers.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010
  2. If you want to insert page numbers in a single worksheet, just select one like this.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010
  3. If you want to select multiple worksheets, select one, hold "Ctrl" key and then select other sheets.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010
  4. Then you will get the view like this. Then "Group" appears in the title bar at the top of the worksheet.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010
  5. If you want to cancel a selection of multiple worksheets in a workbook, right click the tab of a selected sheet, and then click "Ungroup Sheets" on the shortcut menu.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010
  6. Well, go back to insert page numbers. You need to go to "Page Layout" > "PageSetup". Then click the launcher.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010
  7. Select "Header/Footer" panel in the dialog box. And click "Custom Header" or "Custom Footer" button.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010
  8. Then in the "Header" dialog box, select one section "Left", "Center", "Right" for the header text.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010
  9. Click the "Insert Page Number" button and then The placeholder "&[Page]" appears in the section like this.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010
  10. If you also want to add the total number of pages, type a space after "&[Page]", type the word "of" followed by a space and then click the "Insert Number of Pages" button. Also you can see "&[Page] of &[Pages]" appears.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010-
  11. Click "OK" later.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010
  12. Click "OK" to close "Page Setup" window.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010
  13. Well, you can see the header with page numbers as follows.
    Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010

Tips

See also

How to Insert a Page Break in Excel 2010
Page beaks are dividers that break a worksheet into separate pages for printing. Microsoft Excel inserts automatic page breaks . But sometimes, we need to use our own page breaks with customized paper size, margin settings, scale options, etc. At this time, we can insert manual page breaks. Then I will tell you how to do this in Microsoft Excel 2010.
How to Add Side Numbers or Notes Page Numbers in PowerPoint 2010
Like you add date and time to your slides in Microsoft PowerPoint 2010, it is also pretty useful to add slide numbers or notes page numbers in PowerPoint 2010. The slide numbers will give you your process when you give presentation. And it will give your slides neater when you print the presentation. So let me tell you how to add slide numbers or notes page numbers in PowerPoint 2010.
How to Compare Worksheets in Excel 2010
We often use Excel to deal with large data and they may be quite similar in MS Excel documents. So sometimes, we need to compare them in order to deal data better. Well, there are several freewares to do this job. However, if you are Excel 2010 users, you can get a free add-in to do so not to download those softwares. The method is quite quick and easy.

Search for Related Topics

introduce picklist excel 2010   single email multiple recipients outlook multiple c#   divide single graph multiple views ppt   excel 2010 insert smartcard   multiple correlations excel 2010   excel 2010 multiple spooler   excel 2010 insert border  

Related Unresolved Questions

more »
Options

Authors

Tagged Add my tag

excel 2010 , office 2010 , page numbers , worksheet , insert page microworlds jr , insert page interrupt printdocument c# , insert page a4 fireworks cs5 , reportviewer 2010 page , formule quickpart 2010 page

sponsored ads

Recent Searches

22620454 3gp convert knowhow online wmv   address box dialog insert   chinese chs player subtitles vlc   264 reproductor windows   play point power ubuntu   3lll 64 arquivo baixar como de este mas meu sistema tipo xinput1   tggvn  

Download this software from AFC

Microsoft Excel Viewer 2003 1.0

Last Updated: Sep 10, 2008
License: Freeware
Filesize: 9.93MB

Continue to downloadPower by Afreecodec.com