• Skip to main content

masteryourtech.com

Mobile phones, software, consumer electronic how-to guides

  • iPhone
  • Excel
  • Powerpoint
  • Word
  • Google Drive
You are here: Home / Excel / Where Did the Column Letters and Row Numbers Go in Excel?

Where Did the Column Letters and Row Numbers Go in Excel?

posted on May 10, 2019

The letters at the tops of your columns and to the left of your rows provide information that helps you identify specific cells in your spreadsheet. This is beneficial both for when you are discussing the spreadsheet with someone, or when you are creating formulas.

So if you open your spreadsheet in Excel and find that those column letters and row numbers aren’t there, then it can make it difficult to work. Fortunately it’s possible to adjust a setting in the file and make the headings visible again.

How to Display Headings in Excel

The steps in this article were performed in the Microsoft Excel for Office 365 version of the program. Note that we are discussing the column letters at the top of the spreadsheet and the row numbers at the left side of the spreadsheet.

Step 1: Open your file in Excel.

Step 2: Click the Page Layout tab at the top of the window.

click the page layout tab

Step 3: Check the box to the left of View under Headings.

where did the column letters and row numbers go in excel

You may notice that there is also a Print option directly under this. If you find that you need to be able to include those headings on the printed version of your spreadsheet, then you will want to check that option as well.

If your spreadsheet is printing at the left side of the window, then find out how to center it horizontally so that it looks better when you print it.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Filed Under: Excel

Search

  • Contact Us
  • Privacy Policy
  • Terms and Conditions

Copyright © 2022 MasterYourTech.com

 

Loading Comments...
 

You must be logged in to post a comment.