Expanding and collapsing a list

There are several ways to control which levels are visible in lists with multiple levels. Depending on the list, you can use one or more of the following methods.

Expand or collapse one level

Method	Expand	Collapse
Home tab > Spreadsheet Actions
Mouse	Double-click an entry (except lowest level)	Double-click an entry (except lowest level)
Keys	[®]	[¬]

Expand or collapse all levels

Method	Expand All	Collapse All
Home tab > Spreadsheet Actions
Shortcut menu	Expand All	Collapse All
Mouse	[Expand All]	[Collapse All]