Goal Seek, data tables, scenarios and Solver
Updated November 13, 2026
These tools are on Data, under Forecast and Analyze.
Goal seek
- Choose Data › Goal seek.
- Set cell: the formula. To value: the answer you want. By changing cell: the input to change.
- Choose OK. Keep the result or go back.
Data table
- Lay out the inputs to try in a row or column next to a formula, select the block, and choose Data › Data table. Give the row or column input cell. Each result fills in.
Scenario manager
- Save sets of input values as scenarios, show each one in the sheet, and make a summary that compares them.
Solver
- Choose Data › Solver.
- Set the objective cell to make as large or small as possible, or equal to a value.
- Give the cells it can change, and Add constraints such as
B2 <= 100or whole numbers only. - Pick a method: Simplex LP for linear problems, GRG Nonlinear for smooth ones, or Evolutionary for others.
- Choose Solve, then keep the solution or go back. Solver can add an Answer report.