How to Expand and Collapse Rows in Excel: Easy Steps

1. Collapse Rows in Excel

• Group your dataset. You can either use an auto outline (with subtotal rows) or group rows manually.

Steps

• Select the range C5:C7.

• Go to the Data tab
• In the Outline group, select Group.

• In the Group option, select Group.

• Select grouping rows or columns. Click ‘OK’.

• A group from C5 to C7 will be created.

• You can create more groups:

When you manually group rows with two or more levels of information all data should be displayed to prevent incorrect grouping.

Click Minus (-) at the bottom the group to collapse rows or use Hide Details.

1. 1. Clicking Minus to Collapse Rows

Steps

• Create a group before collapsing rows.

• Click the first Minus (-). All rows from C5 to C7 will collapse. Minus (-) will then convert to Plus (+):

Read More: How to Create Collapsible Rows in Excel 

1.2. Collapse Rows Using the Hide Details Feature

Steps

• Select the group of rows you want to collapse.

• Go to the Data tab on the ribbon and click Hide Details.

2. Expand Rows in Excel

1. Clicking The Plus Button to Expand Rows

Steps

• When you collapse a group of rows, a Plus (+) button will appear.

• Click Plus (+) to expand rows.

Read More: How to Expand or Collapse Rows with Plus Sign in Excel

2. Expand Rows Using The Show Details Feature

Steps

• Select cell C8.

• Go to the Data tab on the ribbon and select Show Details to expand rows.

Download Practice Workbook

Related Articles

• How to Lock Rows in Excel
  
• How to Resize All Rows in Excel
• How to Create Rows within a Cell in Excel
• How to Copy Every Nth Row in Excel
• How to Color Alternate Rows in Excel

<< Go Back to Rows in Excel | Learn Excel