in this tutorial we’ll discuss how to easily unhide a row or column in a worksheet when you have multiple ones hidden, and you don’t want to have to unhide the entire group to see a single row or column.
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
Here I have two sets of values for years 2000 to 2015, Budget and Actual. I’m using the Grouping option to hide the details of the months. I’ve also included a small chart to show which column each month’s data is in:
Here the data is expanded to show the full worksheet:
Having it back to collapsed, I want to be able to display the Actual values only for May. By the chart I have, I can see that’s in column F. So, I’ll hit my F5 key which brings up the Go To dialog box and enter cell F1 to choose a cell in that column:
When I hit OK, you’ll see by the Name Box that my cursor is now in cell F1:
You can also just go up into the Nam Box and type F1 in and when you hit Enter, your cursor will now be in cell F1. Now, I’ll go to the Home tab, then to the Cells group, click the down arrow under Format, and follow it down to Hide & Unhide, then choose Unhide Columns:
And now just column F is unhidden:
You can use that same concept for any row or column. But if you would rather not use your mouse, you can use the Key Tips to access the same command on the Ribbon.
For Columns use: Alt H O U L
For Rows use: Alt H O U O
What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!