Can Excel Goal Seek Multiple Cells at Once?

No. In Microsoft Excel for Microsoft 365 on Windows, Goal Seek can adjust only one changing cell to make one formula cell reach one target value per run. To adjust several input cells together, use Solver; to solve several separate cases, run Goal Seek repeatedly, manually or with automation.

What Goal Seek is designed to do

Goal Seek is Excel’s basic what-if analysis tool for working backward from a result. You provide a formula cell, the result you want it to show, and one input cell that Excel may change. Excel then searches for an input value that makes the formula match the target.

For example, you might know your desired profit and want to find the sales price that would produce it. The profit formula is the result cell, the desired profit is the target, and the price is the changing cell. Goal Seek is useful when you have one unknown input and one output condition, and you do not want to rearrange the formula yourself.

The limitation is part of the feature’s design: a Goal Seek run has one Set cell, one To value, and one By changing cell. It does not offer a range of changing cells, nor can one run impose several target conditions at once.

How a Goal Seek run works

Goal Seek changes the value in its selected input cell, recalculates the worksheet, and checks the result formula. It repeats that process until it gets sufficiently close to the target or cannot find a workable value. It is a numerical search, rather than a command that symbolically rearranges a formula.

In Excel for Microsoft 365 on Windows, select Data > What-If Analysis > Goal Seek. In the dialog, fill in these three fields:

Set cell: the cell containing the formula whose result you want to control.
To value: the target result. Enter a number, not a cell reference or a formula.
By changing cell: the single input cell Excel is allowed to alter.

Choose OK to let Excel search. The status dialog reports whether it found a solution; you can accept the value or cancel and restore the original input. Goal Seek changes the worksheet’s input value, so decide whether to keep that result before moving on.

In desktop Excel for Mac, Goal Seek is also available through the Data tab’s What-If Analysis options, though ribbon labels and placement can differ by release. Excel for the web may not provide the desktop Goal Seek command; if it is unavailable, open the workbook in the Excel desktop app.

Worked example: find a price for a profit target

Suppose a simple sales model has the unit price in B2, units sold in B3, fixed costs in B4, and profit in B5. Enter a starting price of 20 in B2, 500 units in B3, and 3,000 in B4. With that layout, put this formula in B5: =B2*B3-B4. At the starting price, profit is 20 × 500 − 3,000, or 7,000.

To find the price that would produce a profit of 10,000, open Goal Seek and enter B5 as the Set cell, 10000 as the To value, and B2 as the By changing cell. Excel should find a price of 26: 26 × 500 − 3,000 = 10,000. The result is useful as a model calculation, not a guarantee that customers will buy that quantity at that price.

This example also shows why Goal Seek needs a formula cell. If B5 contains a typed number instead of a formula linked to B2, changing B2 cannot affect B5, so there is no relationship for Excel to search. Check that the selected changing cell actually feeds into the selected result formula.

Multiple changing cells are a job for Solver

If one formula depends on several inputs and you want Excel to adjust those inputs together, use the Solver add-in. Solver can optimize an objective cell by maximizing it, minimizing it, or setting it to a chosen value, while changing multiple variable cells and observing constraints that you specify.

For example, a production model might calculate profit from quantities of several products. The changing cells could be the quantities produced, while constraints limit labor hours, materials, or available production capacity. Solver can search across those decision cells while respecting the constraints. Goal Seek cannot make that kind of multi-input adjustment.

To enable Solver in Excel for Microsoft 365 on Windows, go to File > Options > Add-ins. Beside Manage, choose Excel Add-ins and select Go, then check Solver Add-in and choose OK. After it is enabled, open Data > Solver. In Solver, choose the objective cell, select a goal such as Max, Min, or a specified value, identify the changing variable cells, and add any relevant constraints.

On Excel for Mac, enable the add-in through Tools > Excel Add-ins, select Solver Add-in, and then open Solver from the Data tab. Solver is more flexible than Goal Seek, but it also requires a more carefully defined model. Choose an appropriate solving method and inspect the result; complex or nonlinear models may need different starting values or settings, and a reported solution is not automatically proof that the assumptions are sound.

Several targets are not the same as several inputs

Readers often mean one of two things by multiple cells: several inputs that Excel should change, or several result cells that should reach targets. Goal Seek handles neither as a group. It has one changing cell and one formula target in each run, so specifying several targets is not possible in its dialog.

If you need several formula cells to meet separate requirements, Solver may be able to handle them as constraints. For instance, you could specify one objective and add conditions for multiple formula cells. Whether the model has a solution depends on the relationships among the formulas and the conditions. If the conditions conflict, no tool can produce values that satisfy all of them at once.

There is another important distinction: using Goal Seek on two outputs that share the same input does not preserve both targets. The second run changes the input again, which can move the first output away from its target. If each output has its own independent input, you can run Goal Seek separately for each pair and keep track of which input and target belong together.

Running separate Goal Seek cases

For a small number of independent questions, repeat the command manually. Record the target, formula cell, changing cell, and resulting input for each run. If a later run should start from the original model, restore the original input first; otherwise, its starting point may be the value left by the previous run.

For many repeated cases, consider a structured worksheet or a VBA macro that calls Goal Seek once per case. Automation can save clicks, but it does not turn Goal Seek into a simultaneous multi-cell solver: each call still works on one formula target and one changing cell. A macro also needs clear rules for resetting inputs, recording outcomes, and handling cases with no solution. Save a copy of the workbook before running macros, because macro actions cannot be undone with Ctrl+Z.

For a range of possible input values and their calculated outputs, a one-variable or two-variable Excel data table may be more suitable than repeated Goal Seek runs. A data table evaluates selected input scenarios; it does not search for an input that satisfies multiple targets. Choose it when you want to compare outcomes across a grid of assumptions rather than solve backward for one value.

Common problems and limits

Goal Seek may stop without reaching the target, or find an unexpected value, when the model is discontinuous, has multiple possible answers, or cannot reach the requested result. A formula involving thresholds, rounding, lookup changes, or IF branches can jump over a target instead of varying smoothly. In that situation, inspect the formula and test nearby input values rather than assuming the first result is the only possible answer.

The starting value matters because Excel searches numerically from the current state of the changing cell. If a formula has multiple solutions, a different starting value may lead to a different one. If the desired input must stay within a range or satisfy other conditions, Goal Seek does not provide the same constraint controls as Solver; check the result yourself or build the restrictions into a suitable Solver model.

Confirm that Set cell contains a formula and that it depends on the changing cell.
Check that the target is attainable for the model’s inputs and assumptions.
Use a sensible starting value and inspect whether multiple solutions are plausible.
After accepting a result, verify related formulas and constraints because Goal Seek controls only its selected target.

Choosing the right Excel tool

Use Goal Seek when one formula result should reach one number by changing one input. Use Solver when several inputs may change together, or when an objective must meet additional conditions. Use repeated Goal Seek runs when you have multiple independent one-input questions. Use a data table when the aim is to compare a set of scenarios, not to find a solution.

Before choosing, write down what the model is meant to do: which outputs matter, which inputs are adjustable, and which limits cannot be violated. That small planning step helps distinguish a straightforward Goal Seek question from a multi-variable optimization problem. It can also reveal that a formula needs to be corrected before any what-if tool will give a meaningful answer.

Frequently Asked Questions

Can Goal Seek change two cells at the same time?
No. A Goal Seek run accepts only one By changing cell. Use Solver if the model requires Excel to adjust multiple inputs together.

Can Goal Seek make two formula cells reach target values?
Not in one run. Goal Seek has one Set cell and one target value. Solver may be able to represent multiple target conditions as constraints, provided the model has a feasible solution.

Can I run Goal Seek on several cells one after another?
Yes, by running it separately for each formula-and-input pair. Remember that each run changes a worksheet value, so later runs can affect earlier results if they share cells or depend on one another.

Is Solver included with Excel?
Solver is an Excel add-in that is typically available to enable in desktop Excel, but it may need to be turned on. On Windows, use File > Options > Add-ins; on Mac, use Tools > Excel Add-ins.

Does Goal Seek work in Excel for the web?
Availability differs from desktop Excel, and the desktop Goal Seek command may not be present in the web app. Open the workbook in desktop Excel for Windows or Mac if you cannot find the command.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.