O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, 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

You can use the Consolidate dialog box (choose Data, Consolidate), shown in Figure 9-34, to combine the values from a set of worksheets in the same workbook or from different workbooks. The Consolidate command allows you to assemble information from as many as 255 supporting worksheets into a single master worksheet.

The default function in the Consolidate dialog box is Sum.

Figure 9-34. 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, you can use the Consolidate command to create a master worksheet that comprises the totals for the corresponding ...

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