Having difficulty unhiding the top most rows or the left most columns? Here is a simple way of doing is without remembering shortcuts. Here is a simple example.
- You first need to make sure that you can see the rows and columns. Goto Tools>Options>View Tab and then make sure there is a check mark by “Row & Column Headers”.
- Now notice the top most left corner - notice the top corner starts are row 4 and column D.
- Just highlight the Row 4 and then drag up and goto Format>Row>Unhide
- Highlight Column D and drag left and goto Format>Column>Unhide
- Now you are done!
Simple to do without having to remembering shortcuts!