How to Use Data Tables in Excel


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

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.

Related Searches


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


You May Also Like

Related Searches

Check It Out

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

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