Producing estimates > Working in the spreadsheet > Changing how the spreadsheet looks > Collapsing or expanding the spreadsheet details

Collapsing or expanding the spreadsheet details

The spreadsheet can show up to three levels of detail. You can collapse or expand the spreadsheet while you work based on how much detail you want to see.

To collapse the entire spreadsheet one level:
- On the ribbon, from the Spreadsheet Display group on the Home tab, click the [Collapse] button.
- Iin classic view, click View > Collapse, or click on the toolbar.
To expand the entire spreadsheet one level:
- On the ribbon, from the Spreadsheet Display group on the Home tab, click the [Expand] button.
- In classic view, click View menu > Expand, or click on the toolbar.
To collapse or expand a specific level, double-click the row header of the level you want to collapse or expand.

For example, to expand a phase to display the items within the phase, double-click the row header for the phase.

Tips:

Do you want your estimates to always open with the spreadsheet fully expanded? In the Spreadsheet options of the Preferences tab (in the Estimating Management Console), select the Open estimate spreadsheet expanded check box located on the Spreadsheet tab.
You can configure the Spreadsheet report to look just like your current spreadsheet, with collapsed or expanded levels, when you click [Prefill from Spreadsheet] on the Spreadsheet Report Options window. Refer to Help topic Spreadsheet report for more information.