The shortcuts of the week are how to hide and unhide columns.
Step 1: Select the column you wish to hide by clicking on the B in this example.
Step 2: Using the Excel Skin as a guide, press the following keys:
The “Hide Column” shortcut is very simple. It only uses one modifier key and the 0 key. Taking a quick look at your Excel Skin you can see that the “control” modifier key is the only modifier key that has yellow text. This is helpful to remember when looking at other yellow text shortcuts.
After hiding a column it may seem gone forever, but have no fear. Unhiding a column is just as easy as hiding one.
Step 1: Select the columns on either side of the column you hid. For example above we hid the B column, so to unhide B we select both the A and C columns.
Step 2: Once again using your Excel Skin as a guide, press the following keys:
The “Unhide Column” shortcut is the same as the “Hide Column” shortcut + the “Shift” modifier key. Luckily you don’t have to memorize that because the Excel Skin easily maps it out for you!
Hiding columns is useful for a plethora of reasons. Maybe your worksheet has information you don’t want others to see, or perhaps the column is holding data in your endless spreadsheet that is just a necessary annoyance. Hidden columns can also serve the purpose of hiding formulas without messing with their functions. The “Unhide Column” shortcut is used for those times that your hidden information needs to come out of hiding for editing and modifications.
Comments will be approved before showing up.