Learn more

Collapsing or expanding the spreadsheet details

Expanding and collapsing a list

Expand/Collapse commands

Use these commands (Home tab > Spreadsheet Display group, or in classic view, the Home menu)to control which levels are visible in the spreadsheet. Each time you select the command, it displays the spreadsheet with one less or one more level of detail.