Goal Seek, data tables, scenarios and Solver

Updated November 13, 2026

These tools are on Data, under Forecast and Analyze.

Goal seek

  1. Choose Data › Goal seek.
  2. Set cell: the formula. To value: the answer you want. By changing cell: the input to change.
  3. 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

  1. Choose Data › Solver.
  2. Set the objective cell to make as large or small as possible, or equal to a value.
  3. Give the cells it can change, and Add constraints such as B2 <= 100 or whole numbers only.
  4. Pick a method: Simplex LP for linear problems, GRG Nonlinear for smooth ones, or Evolutionary for others.
  5. Choose Solve, then keep the solution or go back. Solver can add an Answer report.

Was this article helpful?