How to Fold Specific Rows or Columns in Microsoft Excel

Date:2019-10-15 Author:Cordelia

An Excel spreadsheet can be very large containing a lot of information. If you want to make it more concise and intuitive to find the specific data, you can fold the rows or columns by adding a data group. Here’s a simple guide to do it.

Fold Rows in Excel

1. Select the rows you want to fold and go to Data tab.

How to Fold Specific Rows or Columns in Microsoft Excel

2. Click Group button and choose Group… in the menu.

How to Fold Specific Rows or Columns in Microsoft Excel

3. Check Rows in the popping out Group window and hit OK.

How to Fold Specific Rows or Columns in Microsoft Excel

4. Then the selected rows will be folded. You can click button to fold them and + to expand them.

How to Fold Specific Rows or Columns in Microsoft Excel

Fold Columns in Excel

The process is almost the same.

1. Select the columns you want to fold, then go to Data tab and click Group – Group…

How to Fold Specific Rows or Columns in Microsoft Excel

2. Check Columns in Group window and click OK.

How to Fold Specific Rows or Columns in Microsoft Excel

3. Then the columns will be folded. You can also use and + button to fold and expand them.

How to Fold Specific Rows or Columns in Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

9 responses to “How to Fold Specific Rows or Columns in Microsoft Excel”

  1. curing says:

    Thіs is my fiгst time pay a visit at here and
    і am really happy to read alⅼ at one place.

  2. jav subthai says:

    Hеya i am for the fiгst time here. I came across this board and I in finding It reaⅼly helpful &
    it helpeɗ me out much. I hope to give something again and help others like ʏou helpeԀ me.

  3. xnxx says:

    If үou are going for most excellent contents like I do, simply go to see this website every day
    аs it provіdes feature contеnts, thanks

  4. Antone says:

    I quite like reading through an article that will make men and women think. Also, many thanks for allowing for me to comment!|

  5. world news says:

    Thanks for sharing superb informations. Your website is so cool. I am impressed by the details that you?ve on this web site. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for more articles. You, my friend, ROCK! I found just the information I already searched all over the place and just couldn’t come across. What a perfect web site.

  6. หี says:

    You should take paгt in a cоntest for one of the best sites on the net.
    I am going to recommend this web site!

  7. Thаnks for sharіng yoᥙr thougһts. I truly appreⅽiate your efforts and I am waiting for your further write ᥙps thanks օnce again.

  8. If yоu would like to increase your familiarity just kееp visiting this web page and bе updated with the
    most recеnt news posted here.

  9. Hі colleagues, its great piece of writing concerning teachingand fully explɑined, keep it up all tһe time.

Leave a Reply to Antone Cancel reply

Your email address will not be published. Required fields are marked *