At times, in Excel worksheet the first row(Row 1) or first column(column A) doesnot show up. It is tricky to unhide the first row or column as there is no easy way to do it. Based on the situation, you need to apply different method to access the first row or column. So here is the quick possible reasons for hidden first row or first column.
Reasons and Solutions for Hidden First Row or First Column
Reasons and Solutions for Hidden First Row or First Column
- The row or column is hidden: Most of the time we might have hidden that row or column. Unhiding first row or column is as said earlier is not easy. For doing so, simplest method is to select whole sheet and right click and select Unhide.
- Another possibility is freezed columns or rows: If a excel worksheet has freezed row or columns, then also you will not be able to access some rows and column. Try Unfreezing by going to View->Freeze Panels.
- Row or Column size reduced to very small: Some excel worksheet which we get has very small sized row or column which we cannot see the row or column. In this scenario, select entire worksheet by selecting entire row. Right click and increase row height. If it is column, then select columns and enter higher column width.
Other solutions for unhiding first row or column:
- In the Name Box next to the formula bar, type A1 and then press ENTER.
- On the Home tab, in the Editing group, click Find & Select, and then click Go To. In the Reference box, type A1 and then click OK.
Hope these steps helped you to unhide your excel worksheet first row or column. Still if you have any problems share it in the comment section below.