How to Use Data Tables in Excel

Excel 2003
1. Open a new workbook.
2. Select the 'Data' tab.
3. Click 'Table.' Excel will create a table on your worksheet.
4. Create the data for your table. For example, you may have a set of values in column A and a formula you want to use in column B1 (there's no need to retype the formula, the table will carry it down for you).
5. Open a workbook.
6. Click on the 'Insert' tab, and then click 'Table.'
7. Provide the source of the data for the table. For example, if your data is in cells A1 through A10, then enter 'A1:A10' in the source box.
8. Click 'OK.' Excel will enter a table onto the worksheet.