How to Use Data Tables in Excel

Save

Excel tables are designed so that you can see how different inputs affect the same formula. If you want to use a formula multiple times in a regular Excel workbook, you either have to type the formula each time you use it, or copy it to multiple locations. With an Excel table, the table does the work for you, inserting your inputs into a formula.

Excel 2003

  • Open a new workbook.

  • Select the "Data" tab.

  • Click "Table." Excel will create a table on your worksheet.

  • 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).

  • Open a workbook.

  • Click on the "Insert" tab, and then click "Table."

  • 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.

  • Click "OK." Excel will enter a table onto the worksheet.

Tips & Warnings

  • If you put a formula in your table, it must refer to an input cell. An input cell can be anywhere on a worksheet, and it's where you'll type in your data to use a formula. For example, the formula "=C4*22" refers to the input cell C4.

References

  • Photo Credit computer image by Ewe Degiampietro from Fotolia.com
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!