Hide/Show Unnecessary Excel Rows and Columns

 In Uncategorized

Excel Rows and Columns

Excel Rows and Columns

Play Game Now
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.

Example Excel Hot Keys

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”.

Hide Excel rows and columns

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.

Excel Grouping

 

Play Game Now

Recent Posts

Leave a Comment

How can we
help you?
Contact Us

Please, leave a message and we'll get back to you asap

0

Try Excel Game

for FREE