Latest Post

Abbeam Institute of Technology – www.abbeam.org Abbeam Institute of Technology Fees

How To Number In Excel

Add page numbers on a single worksheet

  1. Click the worksheet for which you want to insert page numbers.
  2. On the Insert tab, in the Text group, click Header & Footer.Excel displays the worksheet in Page Layout view. You can also click Page Layout on the status bar to display this view.
  3. On the worksheet, click Click to add header or Click to add footer.This displays the Header & Footer Tools, adding the Design tab.
  4. To specify where in the header or footer you want the page number to appear, click inside the Left sectionCenter section, or Right section box of the header or footer.
  5. On the Design tab, in the Header & Footer Elements group, click Page Number.The placeholder &[Page] appears in the selected section.If want to add the total number of pages, type a space after &[Page], type the word of followed by a space and then, in the Header & Footer Elements group, click Number of Pages.

    The placeholder &[Page] of &[Pages] appears in the selected section

  6. Click anywhere outside the header or footer area to display the actual page numbers in Page Layout view.
  7. After you have completed working in Page Layout view, on the View tab, in the Workbook Views group, click Normal.You can also click Normal  on the status bar.You can insert page numbers for a worksheet in Page Layout view, where you can see them, or you can use the Page Setup dialog box if you want to insert page numbers for more than one worksheet at the same time. For other sheet types, such as chart sheets, you can insert page numbers only by using the Page Setup dialog box.

Add page numbers in multiple worksheets

You can insert page numbers on multiple worksheets in your workbook by using the Page Setup dialog box. For example, if your workbook contains two worksheets that are both two pages long, the first worksheet will contain two pages numbered 1 and 2. The second worksheet will also contain two pages numbered 1 and 2.

Tip: To add page numbers to all worksheets in a workbook sequentially, you must change the number that each worksheet starts with.

Sponsored Link
  1. Click the worksheets or chart sheets to which you want to add page numbers.
To select Do this
A single sheet Click the sheet tab.

If you don’t see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.

Two or more adjacent sheets Click the tab for the first sheet. Then hold down Shift while you click the tab for the last sheet that you want to select.
Two or more nonadjacent sheets Click the tab for the first sheet. Then hold down Ctrl while you click the tabs of the other sheets that you want to select.
All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

Tip:  When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets.

  1. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher Button image next to Page Setup.
  2. In the Page Setup dialog box, on the Header/Footer tab, click Custom Header or Custom Footer.
  3. To specify where in the header or footer you want the page number to appear, click inside the Left sectionCenter section, or Right section box.
  4. To insert numbers, click the Insert Page Number button.The placeholder &[Page] appears in the selected section.

    Notes:

    • If you 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.
    • The placeholder &[Page] of &[Pages] appears in the selected section.

Set a different number for the starting page

To number all of the worksheet pages in a workbook sequentially, first add page numbers to all worksheets in a workbook, and then use the following procedure to begin the page number for each worksheet with the appropriate number. For example, if your workbook contains two worksheets that with both be printed as two pages, you would use this procedure to begin the page numbering for the second worksheet with the number 3.

  1. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher Button image next to Page Setup.
  2. On the Page tab, in the First page number box, type the number that you want to use for the first page.To use the default numbering system, type Auto in the First page number box.

Change the order in which pages are numbered

By default, Excel numbers and prints pages from the top down and then left to right on the worksheet, but you can change the direction to number and print pages from left to right and then from the top down.

  1. Click the worksheet for which you want to change the numbering order.
  2. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher next to Page Setup.
  3. On the Sheet tab, under Page order, click Down, then over or Over, then down.The direction of each option is displayed in the preview box.

Delete page numbers

  1. Click the worksheets or chart sheets for which you want to remove page numbers.
To select Do this
A single sheet Click the sheet tab.

Sponsored Link

If you don’t see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.

Two or more adjacent sheets Click the tab for the first sheet. Then hold down Shift while you click the tab for the last sheet that you want to select.
Two or more nonadjacent sheets Click the tab for the first sheet. Then hold down Ctrl while you click the tabs of the other sheets that you want to select.
All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

Tip:  When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

  1. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher  next to Page Setup.
  2. On the Header/Footer tab, in the Header or Footer drop-down box, click (none).

    Note: You may have to scroll to the top of the list to click (none).

     

See Also:

How To Apply Makeup

How To Activate Windows 10

How To Apply For US Visa

How To Answer Query

How To Apply For UK Visa

How To Become Rich

How To Be Successful in Life

How To Bake a Cake

How To Buy Bitcoin

How To Become Fat

How To Create An Email Address

How To Create A Website

How To Create A Blog

How To Change Facebook Name

How To Cook Jollof Rice

How To Create An App

How To Check Airtel Number

How To Download From Youtube

How To Do Makeup

How To Draw

How To Delete My Facebook Account

How To Download Vedios Facebook

How To Drive A  Car

How To Download Movies

How To Earn Money Online

How To Earn Bitcoins

How To Edit PDF File

How To Eat Quail Eggs

How To Eat Bitter Kola

How To Enter University of Ghana

How To Eat Garlic

How To Format A Laptop

How To Flash An Android Phone

How To Fix Weave

How To Get Pink Lips

How To Get A Flat Tummy

How To Gain Weight

How To Get Pregnant

How To Get A Smooth Face

How To Grow Tall

How To Get Bigger Hips

How To Hack

How To Hack WiFi

How To Hack A Phone

How To Have Twins

How To Hard Reset Windows Phone

How To Install Windows 10

How To Install Windows 7

How To Increase Your Height

How To Invest In Bitcoin

How To Improve You Memory

How To Invest

How To Improve Your English

How To Join Max International

How To Join The BNI

How To Join Aim Global

How To Join Bitcoin

How To Join  Jailbreak PS3

How To Join The US Army

How To Know Your MTN Number

How To Know Your Airtel Number

How To Knot a Tie

How To Lose Weight

How To Learn

How To Learn Effectively

How To Lose Weight With Lemon 

How To Lose Belly Fat

How To Lose Arm Fat

How To Learn Mathematics

How To Look Younger

How To Make Money

How To Make Money Online

How To Make Cake

How To Make Pancakes

How To Make Pizza

How To Make Liquid Soap

How To Make Meat Pie

How To Make Spring Rolls

How To Number Pages In Word

How To Name A Company

How To Number Pages In Word 2010

How To Network Two Computers

How To Narrate A Story

How To Number Pages In Excel

How To Number In Excel

How To Network A Printer

How To Network Computers

How To Network

How To Open A Bitcoin Account

How To Open A Paypal Account

How To Off iPhone X

How To Organize An Event

How To Operate Excavator

How To Reset Windows Phone

How To Root An Android Phone

How To Reset iPhone

How To Reduce Weight

How To Remove Right Protection

How To Reference A Website

How To Restart iPhone

How To Screenshot On iPhone

How To Start A Business

How To Speak Good English

How To Save Money

How To Tie A Tie

How To Treat Candidiasis

How To Treat Pimples

How To Transfer MTN Credit

How To Use Black Seed

How To Use Bitcoin

How To Unlock iCloud

How To Use Excel

How To Use Snapchat

How To Use Cinnamon

How To Unlock iPhone

How To Update ios

How To Update Windows 10

How To Verify Original iPhone

How To Verify My Apple ID

How To Verify Your Facebook Account

How To Verify Twitter Account

How To Value A Company

How To Verify Your Instagram Account

How To Write An Application Letter

How To Write A Report

How To Write A CV

How To Write A Proposal

How To Write Business Proposal

How To Write An Article

How To Write A Memo

How To Write A Business Plan

How To Write Minute

How To Write Manifesto

How To Xender Connect To PC

How To Zip A Folder

How To Zip Documents

How To Zoom In On PC

How To Zoom In Photoshop

How To Zip A File In Windows 10

How To Zip A Folder In Linux

How To Zip A File In Linux

How To Zoom Out On A PC

How To Zoom In On Mac

Leave a Reply

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