OBINTUSACADEMY
HOME CONTACT SERVICES PRIVACY
COMPUTER BASICS MS-PACKAGES
Excel - Page Numbering

MICROSOFT EXCEL

MODULE ONE

Prerequisite Introduction to Microsoft Excel Getting Started MS Excel Environment Title Bar Quick Access Toolbar Search Account Name Buttons Menu Tab Ribbons Dialog Box Launcher Name Box Insert Function Formula Bar Worksheet Area Worksheet Navigation Creating New Sheet Status Bar Worksheet View Format Zoom Slider MS Excel File Tab Entering Data Saving Your Workbook Opening Saved Workbook Copy, Delete and Hiding Sheet Closing Entire Workbook

MODULE TWO

Cells, Rows and Columns Resizing Rows and Columns Inserting Data Select, Delete and Move Data Copy, Paste and Cut Find and Replace Checking Spellings Inserting TextBox Inserting Symbols Inserting Special Characters Zooming Undoing and Redoing Changes

MODULE THREE

Mini Toolbar Setting Fonts Text Decoration Setting Text Case Text Alignments Text Orientation Increase and Decrease Indentation Wraping Text Merging Cells Cells Borders Cells Shades Copy Formatting Insert and Delete Worksheet Format Worksheet, Cells, Rows and Columns

MODULE FOUR

Insert Tables Insert Pictures Insert Shapes and Smart Art Insert Screenshots Insert Icons Insert 3D-Models Using Add-ins Insert Charts 3D Maps Creating Sparklines Insert WordArt

MODULE FIVE

Addition Subtraction Multiplication Division Using Formulas Using Functions Quick Functions

MODULE SIX

Fill Handling Sorting Filtering References (Relative and Absolute) Conditional Formatting Applying Styles

MODULE SEVEN

Page Themes Page Colors Page Fonts Page Effects Page Header and Footer Page Numbering Page Margins Page Orientation and Size Print Area Page Breaks Setting Background Print Titles Preview and Print Share Workbook Freezing Panes Range Data Validation Excel Templates MS Excel Shortcuts Conclusion

HOW TO

Excel How-To Send Email Separate Text Date and Time Format Macro Thesaurus Insert Comments Password Workbook Count Characters Count Words Add and Remove Hyperlinks Insert PDF in Excel Editing and Formatting Restrictions How to Compare Columns How to Compare Worksheets Add Signature in Worksheet Calculate Age Calculate Mean Calculate Median Calculate Standard Deviation Find the Mode Add and Remove Commas How to Remove Filter Convert Excel to CSV Excel to PDF Excel to Ms-Word Document Excel to Picture Formats Duplicate Rows and Columns Hide and Unhide Rows and Columns Rows and Columns Conversion How to Remove Gridlines Create Graphs Insert Check Box Add and Remove Watermark Logical Operators Logical Functions Text Functions Square Symbol Pi Symbol Selecting Different Columns Creating QR Code Creating Bar Code Insert Bullet Points Generate Random Numbers Combine Two Columns Wrap Text Create Dropdown List

Page Numbering

PREVIOUS NEXT

Page Numbering most times is usually important in most document especially for large number of worksheets. To add page number to an excel worksheet, just follow the simple steps below.

  • ADDING PAGE NUMBERS
  • Step 1 - Open your excel worksheet that you want to add page number to. Make sure you have some data already in it.
    Click on the Insert tab, then go to the far-right side of the insert ribbon and click the Text option which will bring out the Text Group. Inside the text group, click on the Header & Footer option.
    • page-number
  • Step 2 - Your header and footer section will be displayed in the worksheet. Notice you are now on the Header and Footer tab. Now you can add the page number either at the header or the footer. To add page number at the footer, first click on the option Go to Footer inside the navigation group in the header and footer tab.
    • page-number
  • Step 3 - You will be taken to the footer section as shown in the image below.
    • page-number
  • Step 4 - Go to the Header and Footer tab again, inside the Header and Footer Elements group, click on the Page Number option. This will add the page numbering code at the footer of the page.
    • page-number
  • Step 5 - Click anywhere in the worksheet and the page number will be displayed for that particular worksheet.
    • page-number
    note
    NOTE:

    When you add another page, Excel automatically numbers the second page to be 2. You do not need to go through the same process again, it keeps on numbering the pages automatically it increases.

  • Step 6 - Now we have added page number for the current page, but to add the total number of pages click on the footer page number again.
    This will bring out the page numbering code &[Page], after it just type of. Then in the Header and Footer tab, inside the Header and Footer Elements click on the Number of Pages option.
    • page-number
  • Step 7 - The Total number of pages code &[Pages] will be added.
    • page-number
  • Step 8 - Click anywhere in the worksheet and the current page and the total number of pages will be displayed accordingly.
    • page-number
  • ALTERNATIVE METHOD - ADDING PAGE NUMBERS
  • Step 1 - Open your excel worksheet that you want to add page number to. Make sure you have some data already in it.
    Click on the Page Layout tab, then go to the Page Setup group. At the bottom right edge of the group click the dialog box launcher icon that will display the Page Setup Dialog Box.
    • page-number
  • Step 2 - Inside the Page Setup dialog box, click on the Header and Footer tab. Inside that section, click the footer selection dropdown menu icon and from the dropdown options displayed click the type of page numbering that you want. Click the Ok button to save and apply it.
    • page-number
  • Step 3 - The page numbering will be added successfully.
    • page-number
tips
TIP:

If you know the page numbering codes by heart, you can just type in the footer and click anywhere in the worksheet and the page numbering will be inserted instantly.

  • CODES
  • &[Page] - This code displays the current page
  • &[Pages] - This code displays the total number of pages
  • &[Time] - This code displays the current time
  • &[Date] - This code displays the current date
  • &[File] - This code displays the name of the workbook
  • &[Tab] - This code displays the worksheet name
  • &[Path] - This code displays the workbook path.
PREVIOUS NEXT
ADVERTISEMENTS

LEARNING IS A CONTINOUS PROCESS - PRACTICE MAKES PERFECT