How do you create a data table in excel using full data range in the data worksheet?
answer:-
create a blank workbook or worksheet ; select the example in help topic ; press CTRL+C ; in the worksheet , select cell A1, and press CTRL+V ; press formulas tab in the formula auditing.
- Select all cells in the range expect cells A1 and A2.
- Click the DATA tab ,click what if analysis , and then click DATA TABLE.
- In the row input cell box, enter A1 , in the column input cell box , enter A2 , and then click OK.
- Optionally , you can freeze the data table by converting the result to their values.
Get Answers For Free
Most questions answered within 1 hours.