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.

1. 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”.

   

   

2. Now notice the top most left corner - notice the top corner starts are row 4 and column D.

   

3. Just highlight the Row 4 and then drag up and goto Format>Row>Unhide

   

4. Highlight Column D and drag left and goto Format>Column>Unhide

   
   

5. Now you are done!

   

Simple to do without having to remembering shortcuts!

This entry was posted on Saturday, March 15th, 2008 at 1:42 am and is filed under Unhiding. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.