[Fixed!] Missing Row Numbers and Column Letters in Excel (3 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.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


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

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.

excel missing row numbers and column letters


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.

Use View Command to Get Missing Row Numbers and Column Letters in Excel

  • 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.

Read More: Excel VBA: Get Row and Column Number from Cell Address (4 Methods)


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

Apply Page Layout Ribbon to Get Missing Row Numbers and Column Letters in Excel

  • 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.

Read More: [Fixed!] Rows and Columns Are Both Numbers in Excel


Similar Readings


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

Last but not the 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.

Perform Excel Options Command to Get Missing Row Numbers and Column Letters in Excel

  • 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 the Advanced Secondly, check the Show row and column headers under the Display options for this workbook option. At last, press OK.

Perform Excel Options Command to Get Missing Row Numbers and Column Letters in Excel

  • 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.

Perform Excel Options Command to Get Missing Row Numbers and Column Letters in Excel

Read More: Excel VBA: Set Range by Row and Column Number (3 Examples)


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.

Bonus: Missing Row Numbers and Column Letters in Multiple Worksheet

  • Further, from your View tab, go to,

View → Show → Headings

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

Bonus: Missing Row Numbers and Column Letters in Multiple Worksheet


Things to Remember

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

View → Show → Headings


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.


Related Articles

Md. Abdur Rahim Rasel

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

Leave a reply

ExcelDemy
Logo