How Do I Print Out Row Numbers for My Excel Spreadsheet?

Written by mark kennan
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How Do I Print Out Row Numbers for My Excel Spreadsheet?
(BananaStock/BananaStock/Getty Images)

Microsoft Office Excel is a widely used spreadsheet program that is useful for keeping track of numerical data. The program displays row numbers when you are editing the speadsheet on the computer but does not automatically include the row numbers when you print out the spreadsheet. The steps you need to take to include the row numbers when you print depend on your version of Excel. Once you have adjusted the page settings, the row numbers will print automatically.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Select the worksheet whose row numbers you want to print. If you want to have row numbers print on multiple worksheets, you must repeat the process for each worksheet.

  2. 2

    Click "Page Layout" from the options across the top of the screen.

  3. 3

    Locate the "Sheet Options" subgroup, which will be the fourth subgroup from the left.

  4. 4

    Click the box next to "Print" under "Headings" to turn on the row and column titles for printing for the worksheet.

  1. 1

    Select the worksheet whose row numbers you want to print. If you want to have row numbers print on multiple worksheets, you must repeat the process for each worksheet.

  2. 2

    Click "File" from the menus at the top.

  3. 3

    Select "Page Setup" from the drop-down menu, and then click "Sheet Tab."

  4. 4

    Check the box next to "Row and Column Headings," and then click "OK."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.