Hide++Unhide+Excel+Key+Combinations

Hide/Unhide Excel Key Combinations If you want to hide a row, or a column:- The cells you need to highlight a cell in each row or column that you wish to hide. Remember, you do not need a mouse for this either. Just simply hold down the Shift key to start the highlight and use the arrows to select several cells.

Now, use the appropriate key combination: • Ctrl + 0 (zero) will hide the column(s). • Ctrl + 9 will hide the row(s). The columns/rows are now invisible! Need to unhide your data? Highlight two cells, one on either side of the hidden row(s) or column(s).

Again, simply choose the appropriate key combination: • Ctrl + Shift + ) will unhide the columns between the highlighted cells. • Ctrl + Shift + ( will unhide the rows between the highlighted cells. There you have it. Entire rows or columns hidden, without a mouse in hand!  