Outlining and Subtotals Answers

4 verified answers1 views

What needs to be true of the data used for consolidation?

Different types of data are all contained in the same worksheet.

Similar data are located in the same positions in different worksheets.

Outlined data must be collapsed.

The data must be organized with custom views.

3. Click the collapse button next to the field. Select the cells and click the collapse button.

Function

Labels

Links

Reference

1. Click the tab. In the Data Tools group, click Consolidate.

Formulas

Insert

View

Data

What do you click to collapse an entire outline?

Page Layout view in the status bar

scroll boxes in the scroll bars

function button in the formula bar below the Ribbon tabs

boxes with the number 1 near the column and row headers

Did you find these answers helpful?

More from this Course