Browse » Home
Wednesday, September 26, 2012
How to Create a Summary Workbook Excel 2003
1. Type a description of the information that you want to display as a summary on Sheet 1. If you have an income statement on Sheet 2, for example, you can type 'Net Income' in cell A1.
2. Go to the cell you want to show on your summary page. In the above example, you would go to the cell that has net income on Sheet 2.
3. Click 'Copy.'
4. Go back to the summary sheet and click where you want to display the link. In the example, go to cell A2.
5. Click 'Paste' then 'Paste Special.' Choose 'Paste Link.'
6. Repeat these steps for all of the information that you want to include on your summary page.