Let's say you want to help your daughter better understand math concepts by dynamically creating a multiplication table. You can use a two-variable data table (data table: A range of cells that shows the results of substituting different values in one or more formulas. There are two types of data tables: one-input tables and two-input tables.).
- Set up a worksheet with the following structure.
Example
The example may be easier to understand if you copy it to a blank worksheet.
How to copy an example
- Create a blank workbook or worksheet.
- Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
- Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
- Enter a row of values from B3 to the right, for example, 1 through 10.
- Enter a column of values from A4 down, for example, 1 through 10.
- Select all cells in the range except cells A1 and A2.
- On the Data menu, click Table.
- In the Row input cell box, enter A1.
- In the Column input cell box, enter A2.
- Click OK.
- Optionally, you can freeze the data table by converting the result to their values.
How?