O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Consolidating Worksheets

image with no caption

You can use the Consolidate button on the Data tab to combine the values from a set of worksheets in the same workbook or from different workbooks. The Consolidate command lets you assemble information from as many as 255 supporting worksheets in a single master worksheet and displays the Consolidate dialog box shown in Figure 8-71.

The default function in the Consolidate dialog box is Sum.

Figure 8-71. The default function in the Consolidate dialog box is Sum.

For example, if you have data for each month in separate worksheets or financial data for several divisions in separate workbooks, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required