Excel Goal Seek Keyboard Shortcut and How to Use It

In Excel for Microsoft 365 on Windows, the Goal Seek keyboard sequence is Alt+A, W, G; press each key in order rather than holding them all down. You can also open Data > What-If Analysis > Goal Seek to reach the same command.

The Windows shortcut and ribbon path

The shortcut uses Excel ribbon KeyTips. Press Alt to show the available KeyTips, then press A to open the Data tab, W to open What-If Analysis, and G to choose Goal Seek. These are sequential keystrokes, not a simultaneous chord. On an English Microsoft 365 installation with the standard ribbon, this is the usual sequence.

KeyTips can differ if the Office language, ribbon layout, or Excel version differs. If a letter shown on screen does not match the sequence above, follow the letters Excel displays after you press Alt. The reliable mouse route is Data > What-If Analysis > Goal Seek. If the command is not visible on the ribbon, check that the Data tab is selected and look in its What-If Analysis menu.

There is not a single universal shortcut that behaves identically across every Excel installation. The shortcut is especially useful once you know the KeyTips, but the ribbon path is easier to remember and helps confirm that you have selected the correct tool.

What Goal Seek does

Goal Seek is a built-in what-if analysis tool. It works backward from a desired result: you provide a formula cell and a target value, then identify one input cell Excel may change. Excel adjusts that input until the formula result is at, or sufficiently close to, the target.

For example, a worksheet might calculate a monthly payment from a loan amount, interest rate, and term. If the formula is already in place, Goal Seek can estimate the loan amount that would produce a specified payment by changing the amount cell. It does not create the formula, explain whether the target is sensible, or choose among several inputs. The worksheet model must already represent the relationship you want to analyze.

Goal Seek changes one cell at a time. It is appropriate when one unknown input drives one formula result. It is not the same as searching a table of possibilities, changing several assumptions together, or finding the best solution subject to limits.

How to run Goal Seek

Build a formula that calculates the result you want to control. Check that the formula refers to the input cell you intend to adjust.
Open Data > What-If Analysis > Goal Seek, or use the Windows KeyTip sequence Alt+A, W, G.
In Set cell, enter or select the cell containing the formula. This must be a formula result, not a cell where you have typed a fixed number.
In To value, type the numerical result you want. Enter a number, not a formula or a cell reference.
In By changing cell, select the input cell Excel is allowed to adjust. It needs to affect the formula result, directly or through other formulas.
Select OK to let Excel calculate. Review the proposed result, then choose OK to keep it or Cancel to return from the result dialog without accepting the proposed solution.

After accepting the result, inspect both the changed input and the formula cell. Goal Seek writes a new value into the changing cell; it does not save a named scenario or preserve the prior input as a separate case. If the starting value matters, note it or make a copy of the worksheet before running the tool.

A concrete example with a sales target

Suppose B2 contains a unit price of 40, C2 contains 100 units sold, and D2 is the revenue formula. With the unit price in B2 and units in C2, enter =B2*C2 in D2. The current result is 4,000. To find the price that would make revenue 5,000 while units remain fixed, set the Goal Seek fields as follows:

Set cell: D2
To value: 5000
By changing cell: B2

Excel changes B2 to 50, because 50 multiplied by 100 equals 5,000. The formula in D2 remains in place; it is the price input in B2 that changes. This is a simple example of the tool’s intended use: one formula result, one target, and one adjustable input.

The result depends on the model. If the units cell also changes in response to price, Goal Seek may still find a price that makes the formula reach 5,000, but only if the worksheet contains formulas describing how units respond. It cannot infer customer behavior or supply a missing relationship. A technically correct calculation can therefore still be a poor real-world assumption if the underlying model is incomplete.

What Goal Seek can and cannot solve

Goal Seek is useful for a single-variable question, but it has important boundaries. The target cell must contain a formula, and the changing cell must influence that formula. Excel will not adjust several independent assumptions at once, enforce a minimum or maximum for the changing cell, or guarantee that the result is unique.

Some formulas have no solution for a requested target. Others have more than one possible input that reaches the same result. A nonlinear formula may also behave in a way that makes the search sensitive to its starting value. Goal Seek works numerically, so it may return a nearby value rather than an exact match. Check the resulting formula value and the business or mathematical meaning of the input rather than treating a completed dialog as proof that the answer is appropriate.

It is also easy to target the wrong cell. The Set cell box should identify the formula result you want to reach, not the input you want Excel to change. The By changing cell box is the input. Keeping those roles straight avoids a common setup error.

Goal Seek compared with Solver and other tools

Use Goal Seek when there is one desired formula result and one adjustable input. If you need to change multiple cells, impose constraints such as a budget ceiling, or optimize a quantity such as profit, Excel’s Solver add-in is the more relevant tool. Solver is more flexible, but it requires a suitable model and configuration; it is not simply a shortcut for Goal Seek.

For repeated comparisons across many input values, a one-variable or two-variable data table may be more useful. A data table displays how formula results change across a range of selected assumptions, whereas Goal Seek searches for an input that reaches one particular result. Scenario Manager is designed to save and compare sets of input values. These tools answer related but distinct questions, so choose based on whether you need a target, a range of comparisons, saved cases, or constrained optimization.

For instance, if you want the price that produces exactly a chosen revenue, Goal Seek fits. If you want to compare revenue at 40, 45, 50, and 55, a data table is a better fit. If you want the highest profit while keeping costs below a limit and changing both price and production, Solver is better suited to the problem.

Mac and Excel for the web

On Excel for Mac, use the ribbon route Data > What-If Analysis > Goal Seek if that command is available in your build. The Windows sequence Alt+A, W, G is not a dependable Mac shortcut. Ribbon access and keyboard navigation can vary by Mac version and interface, so use the displayed menus rather than assuming the Windows KeyTips will apply.

Excel for the web does not offer the same full Goal Seek workflow as the Windows desktop app in all versions. If you cannot find Goal Seek in the browser ribbon, open the workbook in the Excel desktop app and use the Data tab there. A workbook can still contain formulas and values that you view or edit in the web app; the limitation is access to this analysis command, not the basic ability to calculate the worksheet.

Common problems and practical checks

The command is missing: Confirm you are on the Data tab and open What-If Analysis. If you are using Excel for the web or a different platform, the command may not be available in the same way.
Excel reports a problem with the cells: Make sure Set cell points to a formula, and that the changing cell is a valid input that affects the formula result. Check for a mistyped or unrelated cell reference.
The result seems unreasonable: Review the formula, units, and starting value. Goal Seek does not know that a price should be positive or that a rate should stay within a particular range.
The target is not reached exactly: Recalculate and inspect the formula result. Numerical searches can stop near a target, and rounding or complex formulas can make exact equality impractical.
The answer changes when you rerun it: Check for volatile formulas, circular references, or formulas whose outputs depend on the changing input in unexpected ways. Keep the model as simple and transparent as possible.

For important work, save a copy or record the original input before starting. After Goal Seek finishes, confirm the formula still calculates as intended and that the adjusted value meets any real constraints the worksheet does not enforce. If the result will inform a financial decision, treat the spreadsheet as a calculation aid rather than professional advice, and verify assumptions against the relevant terms or a qualified professional.

Frequently Asked Questions

What is the keyboard shortcut for Goal Seek in Excel?
In Excel for Microsoft 365 on Windows, press Alt+A, W, G in sequence. If the KeyTips differ on your installation, follow the letters displayed after pressing Alt, or use Data > What-If Analysis > Goal Seek.

Do I press Alt+A, W, G all at once?
No. Press Alt, release it, then press A, W, and G one after another as Excel displays the KeyTips. It is a sequence, not a three-key combination held down simultaneously.

Why is Goal Seek greyed out or unavailable?
Check that you are using a desktop Excel version with the command, that the Data tab is available, and that you have selected the appropriate workbook context. The web app may not expose the same command. In the Goal Seek dialog, the target must be a formula cell and the changing cell must affect that formula.

Can Goal Seek change more than one cell?
No. Goal Seek adjusts one changing cell to make one formula cell reach a target. Use Solver when your model needs multiple adjustable cells or constraints.

Does Goal Seek replace the formula?
No. It changes the value in the input cell you specify. The formula in the Set cell remains, and its result updates to reflect the new input.

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.