# [Fixed!] Missing Row Numbers and Column Letters in Excel (3 Solutions)

Get FREE Advanced Excel Exercises with Solutions!

Letâ€™s imagine the following scenario: Youâ€™ve got an Excel file that appears to be pretty good. However, you notice that the row and column headings are missing. That is to say, the numbers 1, 2, and 3 on the left-hand side are not shown, and the letters A, B, and C on the top-hand side are also not visible. We can easily get the missing row numbers and column letters in Excel. This is a time-saving task also. Today, in this article, weâ€™ll learn three quick and suitable ways to get the missing row numbers and column letters in Excel effectively with appropriate illustrations.

## How to Re-Enable Missing Row Numbers and Column Letters in Excel: 3 Suitable Solutions

Letâ€™s assume we have an Excel large worksheet that contains the information about several sales representatives of Armani Group. The name of the Products and the Revenue Earned by the sales representatives are given in Columns C, and D respectively. From our dataset,Â  we notice that the row and column headings are missing. We can easily get the hidden row numbers and column letters in Excel by using the Headings option, Page Layout command, and Excel options command. Hereâ€™s an overview of the dataset for todayâ€™s task.

### 1. Use View Command to Re-Enable Missing Row Numbers and Column Letters in Excel

We can easily show the missing row numbers and column letters in Excel by using the View command. This is the easiest and the most time-saving way in Excel. Letâ€™s follow the instructions below to show the missing row numbers and column letters!

Steps:

• First of all, go to your View After that, From the Show group, check the Headings option.

• After checking the Headings option, you will be able to show the invisible row numbers and column letters in Excel which has been given in the below screenshot.

### 2. Apply Page Layout Ribbon to Re-Enable Missing Row Numbers and Column Letters in Excel

We can also show the missing row numbers and column letters in Excel by using the Page Layout command. Letâ€™s follow the instructions below to show the missing row numbers and column letters!

Steps:

• First, From your Page Layout ribbon, go to,

Page Layout â†’ Sheet Options â†’ Headings â†’ View

• After checking the View option, you will be able to show the missing row numbers and column letters which have been given in the below screenshot.

### 3. Perform Excel Options Command to Re-enable Missing Row Numbers and Column Letters in Excel

Last but not least, You can show the hidden row numbers and column letters in Excel by using the Excel Options command from the File tab. Letâ€™s follow the instructions below to show the missing row numbers and column letters!

Step 1:

• First, click on the File tab.

• After clicking on the File tab, a new window will appear in front of you. Hence, from that window, go to,

More â†’ Options

Step 2:

• As a result, a dialog box named Excel Options will appear in front of you. From the Excel Options dialog box, firstly, select Advanced Secondly, check the Show row and column headers under the Display options for this workbook option. At last, press OK.

• After pressing the OK option, you will be able to show the missing row numbers and column letters which have been given in the below screenshot.

### Re-Enable Missing Row Numbers and Column Letters in Multiple Worksheet

If you show that the row and column headers are missing in the multiple worksheets, you can easily visible it. To do that, follow the instructions below to show the missing row numbers and column letters!

Steps:

• First, select all the worksheets.

• Further, from your View tab, go to,

• After checking the Headings option, you will be able to show the invisible row numbers and column letters in Excel.

## Things to Remember

ðŸ‘‰ You can show the hidden row numbers and column letters in Excel from your View ribbon by following the below instructions:

## Conclusion

I hope all of the suitable methods mentioned above to get the hidden row numbers and column letters will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF