How to Create Summary Workbooks in Excel 2003

Microsoft Excel 2003 is widely used by both companies and individuals to create spreadsheets, charts and graphs and document data. When you find you have compiled dozens of different worksheets related to one project, it can be useful to create a summary workbook, which summarizes all of the information in one place. The summary workbook is particularly useful for short presentations when you need a brief overview of all of the data involved in your project.

• 1

  Launch Excel, and open all of the workbooks you want to summarize.

• 2

  Click the "New" icon to start your summary workbook. Format the cells as you would like them to appear before importing your data.

• 3

  Go to the first workbook you want to include in the summary, and click the cells you want. Click "Ctrl+C" to copy them.

• 4

  Return to your summary workbook, and click the empty cell where you want to include the data. Click the "Home" button and select "Paste" and then "Paste Link." Repeat Steps 3 and 4 with the data in all of your workbooks until your summary is complete.