Two weeks ago we discussed how to hide and unhide columns. In this short blog post I will teach you how to do the same with your rows.
Step 1: Select the row you wish to hide by clicking on the 2 in this example.
Step 2: Using the Excel Skin as a guide, press the following keys:
Just like the “Hide Column” shortcut, the “Hide Rows” shortcut uses just one modifier key: “Control” and the “9” key.
Step 1: Again, just like the process of unhiding columns, we must select the rows on either side of the row that we hid.
Step 2: Using your Excel Skin as a guide, press the following keys:
Your hidden row should now appear. By simply adding the “Shift” modifier key we change the yellow “Hide Rows” shortcut to the light blue “Unhide Rows” Shortcut.
To read more about the uses of hiding rows and columns check out our previous post here: http://www.excelskin.com/blogs/the-excel-skinny/7154640-applying-and-removing-cell-borders-with-excel-skin
P.S. We know hiding your data on Excel is fun but remember to unhide it when handing in those quarterly reports to your boss! He might not like blank spreadsheets as much as we do. (Unless you are a secret spy)
Comments will be approved before showing up.