Give ‘A HOUL’ when you discover hidden columns

When reviewing Excel files in native form, it is important to unhide any hidden rows or columns.  In my experience, it is most often the columns that are hidden.  And these hidden columns often contain the formulas that tell you how all the other data was generated.

You can unhide any hidden columns on a given worksheet by Selecting the entire worksheet with Ctrl+A.  Then go to Format –> Hide & Unhide –> Unhide Columns:


These steps can be reduced to the following keyboard shortcuts:  Ctrl+A and Alt+HOUL

Note:  For Control key shortcuts hold down the Ctrl key; for Alt shortcuts hit the Alt key and let go, and then hit the right sequence of keys.  After you hit the Alt key, Excel will display the letter that will activate the ribbon you want and display the next set of shortcuts.  In this example, choosing H selects the Home Ribbon:


So give A HOUL the next time you discover some hidden columns!

What are your favorite keyboard shortcuts?  Share them in the comments below or email Excel Esquire.  Thanks for reading.

About excelesquire

NYC attorney and Excel enthusiast.
This entry was posted in eDiscovery, Native File Review. Bookmark the permalink.

1 Response to Give ‘A HOUL’ when you discover hidden columns

  1. Pingback: Scared Straight? Reviewing Excel Files in the Wake of Wells Fargo | Excel Esquire

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s