Excel Goal Seek Shortcut: Open It, Set a Target, Solve

In Excel for Microsoft 365 on Windows, open Goal Seek by pressing Alt, then A, W, and G in sequence. You can also select Data > What-If Analysis > Goal Seek; enter the formula cell, target value, and input cell in the dialog, then select OK.

The Windows shortcut and ribbon path

The shortcut is a sequence of ribbon access keys, not four keys pressed all at once. Press and release Alt to show the KeyTips, then press A for the Data tab, W for What-If Analysis, and G for Goal Seek. If the letters shown on your screen differ, follow those KeyTips: they can vary with Excel’s language, ribbon configuration, or version. The menu path is a dependable alternative when you are unsure.

Goal Seek is not assigned a single Ctrl-based shortcut such as Ctrl+G. In this context, Ctrl+G opens Go To, a different Excel command. On Excel for Mac, use Data > What-If Analysis > Goal Seek if the command is available in your build; there is no equivalent Windows Alt-key sequence that applies universally. Excel for the web does not provide the desktop Goal Seek command, so open the workbook in the Excel desktop app to use it.

What Goal Seek does

Goal Seek is a built-in what-if analysis tool. It works backward from a result you want: you give it a formula cell and a target value, then identify one input cell Excel may change. Excel repeatedly recalculates the formula with different values in that input cell until it finds a value that makes the result equal, or sufficiently close, to the target.

For example, a budget formula might calculate how much money remains after expenses. If you need the remainder to be zero, Goal Seek can find the expense or income input that would produce that result. You do not have to rearrange the formula algebraically, which is useful when the calculation has several terms or nested functions. Goal Seek changes a value in the worksheet; it does not rewrite the formula into a new formula that solves the problem automatically.

The tool is deliberately narrow in scope: it changes one variable at a time to reach one target in one formula cell. It is not a general optimizer for multiple decisions, and it does not impose business rules such as minimums, maximums, or whole-number quantities by itself.

How to set up a Goal Seek request

Before opening the dialog, check that the result cell contains a formula and that the input cell is part of that formula’s calculation chain. The input can affect the result directly or through other formulas, but a cell that has no effect on the result cannot help Goal Seek find a solution.

Select Data > What-If Analysis > Goal Seek, or use the Windows access-key sequence.
In Set cell, enter or select the cell containing the formula whose result you want to control.
In To value, type the desired result as a number. This field is a target value, not a formula.
In By changing cell, enter or select the single input cell Excel is allowed to adjust.
Select OK to let Excel calculate. Review the proposed value in the worksheet and choose OK to keep it or Cancel to restore the previous value.

For instance, setting the formula cell to a target of 100 and changing an input cell tells Excel to find an input that makes the formula return 100. The target is not the value to put into the changing cell. Mixing up those two fields is a common reason a request appears to solve the wrong problem.

Worked example: find a price that reaches a profit target

Suppose a small business sells 1,000 units, pays $12 per unit in variable costs, and has $6,000 in fixed costs. Put the selling price in B2, variable cost per unit in B3, units sold in B4, fixed costs in B5, and profit in B6. Start with a selling price of $20 in B2. In this layout, enter this formula in B6:

=(B2-B3)*B4-B5

At the starting price, profit is ($20 − $12) × 1,000 − $6,000, or $2,000. To find the price that produces $5,000 profit, open Goal Seek and set the fields as follows:

Set cell: B6, the profit formula.
To value: 5000.
By changing cell: B2, the selling price.

Excel should find a price of $23. The arithmetic checks: ($23 − $12) × 1,000 − $6,000 = $5,000. The result depends on the assumptions in the other cells staying fixed. If units sold also change when price changes in your real business model, the worksheet needs to represent that relationship before Goal Seek can account for it.

What happens to the worksheet after solving

When Goal Seek finishes, Excel displays a status message indicating whether it found a solution. If you accept the result, the changing cell is left with the value Excel found, while the formula in the Set cell remains in place. Other formulas that depend on those cells recalculate as well. If you cancel the result, Excel restores the changing cell’s earlier value.

The result is a worksheet value, not a saved scenario history. If you need to preserve the original input, copy it to another cell or record it before running Goal Seek. You can also make a copy of the worksheet or workbook before experimenting. This is especially helpful when the input is used throughout a model, because accepting a new value may alter many linked calculations.

Goal Seek is iterative, so it may stop at an approximate answer rather than a value that makes the formula mathematically exact to every decimal place. Display formatting can hide small differences: a cell displayed as 100.00 might contain 99.9998. Increase the displayed decimal places or inspect the underlying value when precision matters.

Common problems and practical checks

If Goal Seek cannot find a satisfactory result, first check the model rather than repeatedly changing the target. The formula must respond to the selected input, and the target must be reachable for some plausible value of that input. A target profit of $5,000 cannot be reached in the example if the input cell is fixed, or if the formula references a different price cell.

Wrong cell selected: Set cell must be the formula result, not the changing input. By changing cell should be the input you intend Excel to vary.
Input has no effect: Trace the formula references to confirm the selected changing cell influences the Set cell. A misspelled or indirect reference can break the expected relationship.
Target is unreachable: The formula may have a limited range of possible results. For example, a percentage constrained elsewhere may never yield the requested total.
Unexpected answer: Check signs, units, and assumptions. A target entered as 5000 is different from 50, and a value stored as 0.5 may display as 50%.
Approximate result: Inspect more decimal places, check calculation settings, and consider whether rounding in the model creates flat or discontinuous results.
Formula returns an error: Resolve errors such as division by zero or invalid references before asking Goal Seek to adjust an input.

There may also be more than one input value that yields the target, particularly when a formula is nonlinear. The starting value can affect which solution an iterative method approaches. Test a reasonable starting value and verify the final result independently, especially before using it in a financial, engineering, or operational decision.

Goal Seek compared with Solver and data tables

Use Goal Seek when the question is, What single input makes this one formula equal a particular number? It is quick for a break-even price, a required interest rate, a needed sales quantity, or a target payment, provided the model is already set up and only one input needs to change.

Use Solver when a problem requires changing multiple decision cells, maximizing or minimizing a result, or enforcing constraints such as nonnegative quantities or a capacity limit. Solver is an Excel add-in and may need to be enabled; it is more flexible, but it requires more setup. A one-variable or two-variable data table is useful for comparing many possible inputs or combinations and seeing their results side by side. Goal Seek instead searches for an input that reaches one specified result.

These tools answer different questions. If you want to compare profit at prices of $20, $21, $22, and $23, a data table may be clearer. If you want the price that reaches exactly $5,000 profit, Goal Seek is the direct choice. If you want the highest profit while keeping price and production within constraints, Solver is more appropriate.

Choosing an input and validating the answer

The best changing cell is a genuine model input that you are allowed to adjust, not an intermediate formula cell. A formula cell cannot serve as the changing cell because Excel needs to overwrite a value to search for the answer. Choose an input with units and meaning that match the decision: price in dollars, units as a quantity, or a rate as a percentage.

After accepting a result, verify it in three ways: check the value Excel placed in the input cell, recalculate or inspect the formula result, and confirm the answer is realistic under the model’s assumptions. In the example, $23 is a valid mathematical solution, but it does not prove customers will still buy 1,000 units at that price. Goal Seek only solves the relationships represented in the spreadsheet; it does not supply missing real-world relationships or judge whether a result makes business sense.

If the answer must be a whole number, Goal Seek may return a decimal because it solves for a numeric input without a built-in integer constraint. Round or test suitable whole-number candidates separately, or use Solver when integer restrictions and other constraints are part of the problem.

Frequently Asked Questions

What is the Goal Seek shortcut in Excel?

In Excel for Microsoft 365 on Windows, press Alt, A, W, and G one after another. Alternatively, choose Data > What-If Analysis > Goal Seek. Follow the on-screen KeyTips if they differ in your version or language.

Why is Goal Seek greyed out or missing?

Check that you are using the desktop version of Excel and that the workbook is open for editing. Excel for the web does not include the desktop Goal Seek command. On Mac or in a different desktop build, look on the Data tab for What-If Analysis; ribbon layout and availability can vary.

Can Goal Seek change more than one cell?

No. Goal Seek adjusts one changing cell to make one formula cell reach one target. For multiple changing cells or constraints, use Solver if the problem fits its capabilities.

Does Goal Seek change the formula?

No. It changes the value in the selected By changing cell and leaves the formula in the Set cell intact. Accepting the result keeps the new input value; canceling restores the prior value.

Why does Goal Seek return an unexpected or approximate value?

The target may be unreachable, the wrong input or result cell may be selected, or the model may have several possible solutions. Goal Seek also uses iterative calculation, so inspect additional decimal places and test that the final input produces the intended result in your model.

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.