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.
Read More: [Fixed!] Rows and Columns Are Both Numbers in Excel
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.
Read More: How to Add Rows and Columns in Excel
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,
View → Show → Headings
- 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:
View → Show → Headings
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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
- How to Find Difference Between Rows and Columns in Excel
- How to Switch Rows and Columns in Excel
- Excel VBA to Set Range Using Row and Column Numbers
- How to Switch Rows and Columns in Excel Chart
- How to Lock Column Width and Row Height in Excel
- Excel VBA: Get Row and Column Number from Cell Address
- How to Delete Empty Rows and Columns in Excel VBA