How to Consolidate Worksheets in Excel

Consolidating Excel worksheets can be a very valuable tool, especially in the corporate world. If you currently have multiple Excel spreadsheets with data that you need to add into one document then all you need to do is consolidate instead of copying the data yourself.

Instructions

Difficulty: Moderate

Things You’ll Need:

• Computer
• Microsoft Excel
• Multiple Excel documents

1. Turn on your computer and open the Excel spreadsheets that need to be consolidated.
2. Consolidate spreadsheets by position, category, formula or by using a PivotTable. For this how-to we are going to be consolidating by category. Begin by making sure the format is identical in each worksheet. For example, "Annual Avg." and "Annual Average" are seen as different and won't consolidate together.
3. Next go to the worksheet that you want to consolidate and click "Data," then choose "Consolidate." This will open the Consolidate box.
4. Specify the range by using the Reference box in the window. Click "Add" to move the range to the "All References" box. Continue adding ranges until all are defined.
5. Check the "Create links to source data" box to add links back to the original data. Then click "Ok" to save and perform the consolidation.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.