Goal Seek in Google Sheets for Excel Users

Does Google Sheets Have Goal Seek?

No. In Excel, Goal Seek sits under Data > What-If Analysis, and most analysts open it with Alt + A + W + G without looking at the ribbon. Google Sheets has no equivalent command in its menus. Google does publish a separate Goal Seek add-on, which you install and then open from the Extensions menu, but it has its own panel and its own steps, so the habit you built in Excel does not carry over.

ShortieCuts puts Goal Seek back on the keys you already know. Press Alt (Option on a Mac), the Excel-style key-tips appear over the sheet, and typing A, W, G opens a Goal Seek dialog with the same three boxes as Excel.

What Goal Seek Actually Does

Goal Seek is a backsolver. You tell it which formula cell you care about, the value you want that cell to show, and which single input it is allowed to change. It then tries values in the input cell, recalculating each time, until the output lands on the target within a tolerance.

Two conditions have to hold for that to work:

• The output must depend on the input. If the Set cell's formula never reaches the By changing cell, no amount of trial and error will move it.
• The input should be a hardcoded number. Goal Seek writes its answer into the By changing cell, so pointing it at a formula would replace that formula with a constant.

How To Run Goal Seek in Google Sheets With ShortieCuts

1. Open the spreadsheet in Chrome with ShortieCuts installed.
2. Press Alt (Option on a Mac). Key-tips appear.
3. Type A, then W, then G. The Goal Seek dialog opens.
4. In Set cell, enter the formula cell you want to hit, for example your operating profit or IRR cell.
5. In To value, enter the target. Plain numbers work, and so do percentages typed as 15%.
6. In By changing cell, enter the hardcoded input Goal Seek may adjust.
7. Start the search. If it runs longer than you expect, press Esc to cancel it.

Advanced Options

The dialog has an Advanced Options section that Excel does not expose. The defaults suit most models, but it helps to know what each one controls.

Option	Default	What It Controls
Max Time Limit (Seconds)	120	How long the search may run before it stops. Each trial waits for the sheet to recalculate, so a large model needs more time per step.
Tolerance	0.001	How close the Set cell must get to the target to count as solved. Tighten it for small-unit targets such as rates; loosen it if you only need the answer to the nearest dollar.
Max Iterations	1000	The cap on the number of trial values. Raise it only if a search keeps stopping just short of the target.

Worked Example: The Price That Hits a Profit Target

Take a simple unit-economics block on a tab called Model:

• B2 units sold: 50,000
• B3 price per unit: $30 (a hardcoded input)
• B4 revenue: =B2*B3
• B5 variable cost per unit: $18
• B6 variable costs: =B2*B5
• B7 fixed costs: $600,000
• B8 operating profit: =B4-B6-B7

At $30 the business breaks even: revenue of $1,500,000 less $900,000 of variable costs and $600,000 of fixed costs leaves zero. The question from the deal team is what price delivers $400,000 of operating profit.

Open Goal Seek with Alt + A + W + G and fill in Set cell B8, To value 400000, By changing cell B3. The search should land on a price of $38. You can check it by hand: 50,000 units at $38 is $1,900,000 of revenue, less $900,000 and $600,000 of costs, which leaves $400,000.

This example is linear, so you could solve it with algebra. Goal Seek earns its keep when the path from input to output is not a straight line: an IRR that depends on exit timing, a debt balance that feeds back into interest, or a tax line with thresholds. The steps are identical.

Solving for a Percentage Target

Return targets are usually percentages. To find the entry price that produces a 20% IRR, set the Set cell to your IRR cell, type 20% in To value, and put the purchase price input in By changing cell. Typing the percent sign avoids the classic mistake of entering 20 and asking the model for a 2,000% return.

Limits and Tips

• One input, one output. Goal Seek changes a single cell to hit a single target. If you need to move several inputs at once or respect constraints, you need an optimizer rather than Goal Seek.
• The answer is a static number. Goal Seek leaves its result in the input cell. If other assumptions change later, the old answer stays put until you run it again.
• Note the original value first. Before you run it on a live model, write down the input's current value so you can put it back.
• Some targets have more than one answer. IRR and other non-linear outputs can hit the same value at two different inputs, or none. As with any iterative solver, a starting input close to the answer you expect generally helps.
• If it will not converge, check the chain. Select the Set cell and press Ctrl + [ to trace its precedents and confirm the input actually feeds it. The trace precedents and dependents guide covers this in detail.
• Heavy models are slower. Every trial waits on a recalculation, so a model with many tabs and lookups may need a higher Max Time Limit.

Other Excel Data-Tab Shortcuts in Sheets

Goal Seek is one of the Alt + A sequences ShortieCuts restores. Others on the same tab include Remove Duplicates (Alt + A + M), Text to Columns (Alt + A + E), Data Validation (Alt + A + V + V), Group (Alt + A + G + G) and Filter (Alt + A + T). The full list is on the shortcuts index, and the broader story of Excel's Alt keys in Sheets is in ALT-key shortcuts for Google Sheets. If you are weighing the two tools more generally, see Google Sheets vs. Excel.

ShortieCuts Pro is $7.99 a month or $69.99 a year, with a 14-day free trial that needs no credit card. Details are on the pricing page.

FAQ