O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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 Multiple Worksheets into a Single Worksheet

When you work with many worksheets, you may need to consolidate worksheets of the same type into a single worksheet. For example, if you have a year's worth of weekly spreadsheets containing sales figures, you may want to consolidate them to get yearly figures.

Excel enables you to consolidate worksheets that have the same layout or worksheets that have different layouts but the same row labels or column labels. You can consolidate up to 255 source worksheets into the destination worksheet, either linking the destination worksheet to the source worksheets or copying the data from the source worksheets to the destination worksheet but not creating a link.

Preparing to Consolidate Worksheets ...

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