Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

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.

Leave a Reply

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