How Do You Create A Consolidated Spreadsheet?
One of the most powerful features of a spreadsheet program is its ability to use multiple worksheets in a single spreadsheet. If you are building an annual budget for your company you can create a worksheet for each quarter, then use a fifth worksheet to consolidate that quarterly data into an annual budget forecast. The instructions that follow are for Microsoft Excel, but the same concept holds true for other spreadsheet programs as well. Log on to your computer and open Microsoft Excel. Create a new spreadsheet and give it a descriptive name like “Consolidated Budget” or “Consolidated Spreadsheet.” Add another sheet if you need to. Make sure you have enough sheets to hold the data you will be consolidating. For instance, if you want to use your spreadsheet to add up quarterly data, you would need a total of five sheets—one for each quarter and fifth sheet to hold the consolidated data. To add a sheet in Excel 2003, click on the “Insert” menu and choose “Worksheet” from the menu. T
