Create a One-Input Data Table : Table « Table « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Table
  3. Table
Enter the formula.
Enter the formula.
Select the data table, including the column or row that contains the new formula.
           Click the Data tab.
           Click the What-If Analysis button, and then click Data Table.
Click the What-If Analysis button, and then click Data Table.
Enter the input cell.
           Click OK.
Click OK.








4.1.Table
4.1.1.Create a TableCreate a Table
4.1.2.Select Entire TableSelect Entire Table
4.1.3.Resize a TableResize a Table
4.1.4.Convert a Table to a RangeConvert a Table to a Range
4.1.5.Enter Data in a List Using Pick From Drop-Down ListEnter Data in a List Using Pick From Drop-Down List
4.1.6.Create a One-Input Data TableCreate a One-Input Data Table