Create a Table in Microsoft Excel

Create a Table in Microsoft Excel

 

 
If you are interested in studying the effect a range of values has on the formula, you can set up a data table. This is a table that consists about the formula you are using, and multiple input values for that formula. Excel automatically creates a solution to the formula for each different input value.

 

 
Do not confuse data tables with the Excel tables that you learned about in “Convert a Range to a Table.” A data table is a special range that Excel uses to calculate multiple solutions to a formula.