Hide/Show Unnecessary Excel Rows and 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
Logo keySkillset

Free educational games

10x faster with the programs you need!

Learn new tricks at up to 5x the rate!

Improve your Excel, PowerPoint, Python, Financial Modeling Skills.