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.




Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips