Hide/Show Unnecessary Excel Rows and Columns

Hide-Show-Excel-Rows-Columns

Let’s assume we’d like to temporary hide some columns in the table below: hide details by months, leaving only quarters. In our example, we’d like to hide rows B to D.

There are two methods for that.

Method 1: Hide Excel rows and columns

Go to the row B and click Excelshortcut “Ctrl + Space Bar” to highlight the row. Then highlight rows C and D by holding “Shift” and clicking the right arrow couple times.

Click Excel hot key “Shift + F10” for right-clicking and “H” to “Hide”.

To unhide you’d click “Shift + F10” for right-clickng and “U” to “Unhide”.

The problem with this method is thatit’s less obvious if the column / row is hidden or not, and there’s more hustle to unhide and hide again.

Grouping is a better way of doing it.

Method 2: Grouping

After selecting the rows B to D, you can click Excel shortcut “Alt + Shift + right arrow” to group the previously selected rows or columns, and “Alt + Shift + left arrow” to ungroup, respectively.

This method of hiding unnecessary data is much more convenient – you can press either a button with the sign “+” or “-“, or Excel shortcut ”Alt A J/H” (clicking one after another in this case) to collapse or unfold the cells.

Share on facebook
Share on twitter
Share on linkedin