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.
Step 3: Check the box to the left of View under Headings.
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.