What is the method to collapse or expand rows & columns in excel sheet?

Posted by:

What is the method to collapse or expand rows & columns in excel sheet?

The simple method to collapse or expand rows & columns in excel sheet are as follows:

Here is a quick step-by-step example to show you how.

Here are the basic steps:

  • First, you have to group the row/column selection
  • THEN, you can collapse or expand that group

Here is how you group rows or columns and then expand/collapse the group:

  • First, you need to group the columns/rows.

 

  • To group the rows (for this example), you need to highlight the rows you’d like in your group. I chose rows 4–9.

 

  • Do this by clicking row 4 in the red circle, holding the cursor down, and dragging the cursor down to row 9. Now you can take your finger off the mouse.

 

method to collapse or expand rows
  • Now, click the DATA tab and click GROUP (this is the exact same on Windows and Mac OS, but looks slightly different).
method to collapse or expand rows
  • You have a row group! You’ll see the group is already Expanded. Take a look in the red rectangle.
method to collapse or expand rows
  • If you click this “ – “ (minus sign) at the bottom, you will collapse the group. This is what the group looks like collapsed.
method to collapse or expand rows
  • Click the plus sign to expand the group.

Grouping, collapsing and expanding columns is exactly the same. You just highlight the column group instead of the rows.

2

Comments

  1. JensJuicy  June 24, 2018

    I often visit your blog and have noticed that you don’t update it often. More frequent updates
    will give your page higher authority & rank in google.
    I know that writing posts takes a lot of time,
    but you can always help yourself with miftolo’s tools which will shorten the time of creating an article to a
    couple of seconds.

  2. Cre8torSahil  June 25, 2018

    Thanks for your suggestion. I will really try it!

Add a Comment