# How to use Goal Seek in Excel on Mac: step by step for Microsoft 365

> Learn how to use Goal Seek in Excel on Mac: the Data tab steps, the dialog fields, Excel for the web limits, and fixes for common errors.

URL: https://www.lazur.app/how-to/use-goal-seek-in-excel
Updated: 2026-11-09

To use Goal Seek in Excel on Mac, open the workbook in the Excel desktop app, go to the Data tab, click What-If Analysis, then click Goal Seek. Enter the formula cell in Set cell, the target value in To value, and the input cell in By changing cell, then click OK.

## Quick answer

- Goal Seek sits at Data > What-If Analysis > Goal Seek in the Excel desktop app.
- It asks for three things: Set cell, To value, and By changing cell.
- It adjusts one input only. Microsoft points to Solver when several inputs must change.
- Excel for the web does not include Goal Seek, so open the file on your Mac in the desktop app.
- Microsoft lists no keyboard shortcut for Goal Seek, so you click with a mouse or trackpad.

Applies to: Excel for Microsoft 365, Excel 2024, and Excel 2021 for Mac. Time: 10 min. Difficulty: Easy.

## What you need

- Excel for Microsoft 365 for Mac, Excel 2024 for Mac, or Excel 2021 for Mac
- The workbook open in the Excel desktop app, not in Excel for the web
- A formula cell whose result depends on one input cell you can change
- A target number that you want the formula to reach
- A note of the original input value, so you can put it back

## How to Use Goal Seek in Excel for Mac in Excel on a Mac

1. **Open the workbook in the desktop app.** Open the file in Excel for Mac, the desktop app on your Mac. Do not work from a browser tab. Goal Seek is not available in Excel for the web, so the command will be missing there. Tip: If a file opened in a browser, choose Open in Excel to move it into the desktop app.
2. **Check the formula chain.** Click the cell that shows the result you care about. Read its formula and confirm it uses the input cell you plan to change. If it does not, fix the chain first. Tip: Read the formula in the formula bar so you see every cell it uses.
3. **Open the Data tab.** (Data) Click the Data tab on the ribbon. The What-If Analysis tools live here. Tip: Microsoft lists no shortcut for the Data tab, so click it with the mouse or trackpad.
4. **Open What-If Analysis.** (Data > What-If Analysis) On the Data tab, click What-If Analysis. Its menu holds the analysis commands, including Goal Seek.
5. **Choose Goal Seek.** (Data > What-If Analysis > Goal Seek) Click Goal Seek. The Goal Seek dialog opens with three fields to fill in. Tip: A community answer places this command under a Forecast group. Microsoft's Mac page does not mention that group, so look for the Goal Seek label.
6. **Fill in Set cell.** In Set cell, enter the cell that holds the formula. Click the cell in the sheet or type its address. This is the result you want to hit.
7. **Fill in To value.** In To value, type the number you want the formula to reach. Enter a plain number, without text or units. Tip: Keep the target in the same units as the result. A revenue target goes in revenue units.
8. **Fill in By changing cell.** In By changing cell, enter the input cell. Goal Seek changes only this cell. Click the cell or type its address. Tip: Write down this cell's current value before you continue, so you can put it back by hand.
9. **Click OK.** Click OK. Goal Seek runs, then shows the Goal Seek Status dialog. Read whether it found a solution and note the new input value.
10. **Check the Set cell.** Look at the Set cell in the sheet. It should show your target or a value very close to it. Results are approximate, so accept the answer only if the gap is small enough for your use.
11. **Format the result.** (Home > Increase Decimal) If the new input shows too many decimal places, use the decimal buttons on the Home tab. Microsoft's Mac page names Increase Decimal and Decrease Decimal. Tip: Formatting changes how the number looks. It does not change the value.

Goal Seek answers a backward question. You already know the result a formula should produce, and you want to know which input value gets you there. Instead of guessing and retyping numbers, you hand the formula to Goal Seek and let it search for the value.

## What you need before you start

Goal Seek is a desktop feature. You need Excel for Mac installed on your Mac, and the workbook must be open in that app. Microsoft's Goal Seek page covers three versions: Excel for Microsoft 365 for Mac, Excel 2024 for Mac, and Excel 2021 for Mac. If you run an older release, check your own menus before you follow the steps, because Microsoft's Mac page does not cover older releases.

- Excel for Microsoft 365 for Mac, Excel 2024 for Mac, or Excel 2021 for Mac
- The workbook open in the Excel desktop app, not in Excel for the web
- A formula cell whose result depends on one input cell you can change
- A target number that you want the formula to reach
- A note of the original input value, so you can put it back

![Person at a desk working on a spreadsheet on a laptop, the kind of Excel work where Goal Seek in Excel on Mac helps.](https://images.lazur.app/content-images/howto/use-goal-seek-in-excel/how-to-use-goal-seek-in-excel-1-5ad3b6.jpg)

## Step by step: Goal Seek on Excel for Mac

The steps below follow Microsoft's Mac instructions. Every move happens with the mouse or trackpad. Microsoft's Mac keyboard shortcut list has no shortcut for Goal Seek, What-If Analysis, or the Data tab. Work through the steps in order the first time, even if you already know Excel well.

- **None** Keyboard shortcuts Microsoft lists for Goal Seek, What-If Analysis, or the Data tab ([source](https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f))
- **macOS 14** Minimum macOS to keep receiving Microsoft 365 and Office for Mac updates ([source](https://learn.microsoft.com/en-us/officeupdates/release-notes-office-for-mac))
- **16.114.3** Newest Excel for Mac build in Microsoft's release notes, dated Oct 27, 2026 ([source](https://learn.microsoft.com/en-us/officeupdates/release-notes-office-for-mac))

## Where What-If Analysis sits on the Data tab

What-If Analysis is a group of tools on the Data tab. Goal Seek is one of its commands. Data Tables sit in the same family of analysis tools, and they also need the desktop app. You reach for Goal Seek when you know the answer you want and need the input that produces it.

## Set up the sheet so Goal Seek can work

Goal Seek needs a chain of cells. One input cell feeds a formula, and that formula produces a result. The result cell goes in Set cell. The input cell goes in By changing cell. If the chain breaks anywhere, Goal Seek cannot move the result.

Take a simple case. Your revenue cell multiplies units sold by price. You want revenue to reach a fixed target. Put the revenue cell in Set cell, the target in To value, and the units cell in By changing cell. Goal Seek then searches for the units value that brings revenue to the target.

> **The formula must read the input:** Microsoft's page says the cell Goal Seek changes must be referenced by the formula in the Set cell. If the formula does not read the input cell, Goal Seek has nothing to adjust. Trace the chain before you open the dialog.

## Reading the three dialog fields

| Field | What goes there | Revenue example |
| --- | --- | --- |
| Set cell | The cell with the formula you want to resolve | The revenue cell |
| To value | The result you want the formula to reach | The target revenue |
| By changing cell | The one input cell Goal Seek is allowed to change | The units sold cell |

_The three Goal Seek fields and what each one expects._

Type the target in To value as a plain number. Use the exact figure you need, not a rounded guess. A rounded target can send the answer somewhere that looks right and still misses your real goal.

## Read the Goal Seek Status dialog before you trust the answer

After you click OK, Excel shows a Goal Seek Status dialog. A community answer on Microsoft's Q&A forum says this dialog shows whether Excel found a solution, along with the new input value. Read that value first, then check the Set cell in the sheet.

Results are approximate. Goal Seek works toward the target and can land a little off it. Accept the value only after the Set cell matches your goal closely enough for your use.

## Why Goal Seek changes only one input

Microsoft's page says Goal Seek works with only one variable input value. When your target depends on two or more inputs, Microsoft points you to the Solver add-in. Goal Seek is the right tool for a single unknown. It is the wrong tool for a model with several unknowns.

One workaround is to fix one input at a value you trust, then run Goal Seek on the other. That only works when the fixed value is reasonable. Treat it as a judgment call, and write down which input you held fixed.

## Goal Seek in Excel for the web and why it is missing

If the command is missing, check whether the file is open in a browser. A Microsoft Q&A community answer says Goal Seek is not available in Excel for the web. The same answer says Goal Seek, Data Tables, Solver, and Series need the Excel desktop app. The web version can show What-If results, but it cannot run those tools.

Microsoft's page on recalculation and iteration says iteration settings are not available in Excel for the web. To change them, open the file in the desktop app through Open in Excel.

| Task | Excel for Mac desktop app | Excel for the web |
| --- | --- | --- |
| Run Goal Seek | Yes, from Data > What-If Analysis | Not available, per a Microsoft Q&A answer |
| Change iteration settings | Yes | Not available, per Microsoft's recalculation page |
| Run Solver, Data Tables, or Series | Yes | Not available, per a Microsoft Q&A answer |
| Show What-If results | Yes | Displays results only |

_Which What-If tools each version of Excel can run._

## Keyboard shortcuts and the ribbon on Mac

Microsoft's list of Excel keyboard shortcuts for Mac has no shortcut for What-If Analysis, Goal Seek, or the Data tab. The list does include ⌘ ⌥ R to expand or minimize the ribbon. Use it when the ribbon is collapsed and you cannot see the Data tab.

The same list says Control+Option starts access keys only in Excel for the web on a Mac. It does not settle how access keys behave in the desktop app, so do not count on them. A mouse or trackpad is the safest route.

## Which Excel for Mac version and macOS you need

Microsoft lists the Goal Seek steps for Excel for Microsoft 365 for Mac, Excel 2024 for Mac, and Excel 2021 for Mac. Microsoft's release notes list the newest Excel for Mac build as 16.114.3, dated Oct 27, 2026. Microsoft describes that release as quality and performance improvements.

Your macOS version matters for updates. Microsoft says a minimum of macOS 14 (Sonoma) is required to receive updates to Microsoft 365 and Office apps. Older macOS versions keep working, but they stop receiving updates, including security updates. Microsoft also says macOS 12 (Monterey) is the minimum to install versions 16.78 or later.

> **Check before you update:** If your Mac runs an older macOS, the Goal Seek steps still match the Excel versions Microsoft lists. You will stop getting Office updates, though, so plan an upgrade before that happens.

## Common mistakes that waste your time

- Typing a fixed number into Set cell. Set cell needs the formula that produces the result.
- Picking an input cell the formula never reads. Goal Seek cannot move a result that does not depend on the input.
- Expecting two inputs to change. Goal Seek adjusts one, so use Solver for more.
- Running the steps in Excel for the web, where the command is not available.
- Skipping the copy of the original input. Write the old value down before you click OK.

Most failed runs come from the first two items. Trace the formula chain again before you rerun the command. A quick check saves a lot of guessing.

## When Excel says it may not have found a solution

Sometimes the Goal Seek Status dialog says Excel may not have found a solution. Community discussions point to two usual causes. Either no exact answer exists for your target, or the Set cell does not link to the By changing cell. Check the link first, since it is the easier fix.

A quick test helps you tell the two causes apart. Pick a target you can reach by hand, for example the result the formula gives for an input you type yourself. If Goal Seek finds that input, your setup works, and the original target was the problem.

## Format the answer so it reads well

Goal Seek writes the input value into your sheet, and that value can carry more decimal places than you want. Microsoft's Mac page says to use Increase Decimal or Decrease Decimal on the Home tab. Those buttons change how the number looks, not the value stored in the cell.

Microsoft's Windows page uses the Percentage button in the Number group for a similar step. On a Mac, skip that button and use the decimal buttons instead.

## A worked example you can test on a small model

Before you run Goal Seek on a live file, build a small test model. Use a blank sheet, so nothing you care about is at risk. The test shows you how the three fields behave before real numbers are involved.

1. Type a starting value into an input cell and label it.
2. Write a formula that uses that input, such as a price multiplied by the input.
3. Pick a target you know the formula can reach.
4. Run Data > What-If Analysis > Goal Seek, then read the Goal Seek Status dialog.
5. Type the new input back in by hand and confirm the formula matches the target.

If the hand check matches, the same steps will work on the real workbook. If it does not match, the formula chain has a gap, and you should fix it before you run the command again.

![Laptop screen showing rows of numbers, the kind of model where you would use Goal Seek in Excel on Mac.](https://images.lazur.app/content-images/howto/use-goal-seek-in-excel/how-to-use-goal-seek-in-excel-2-44ca53.jpg)

## What to do next after Goal Seek

After the first run works, test the answer. Change the target a little and run Goal Seek again. If the input moves in a sensible direction, the model behaves as you expect. If the input jumps around, check each formula between the input and the result.

When you need several inputs, learn Solver next. Microsoft points to Solver for that case, and Solver also needs the desktop app. If you build summary tables from the same data, see [How to make a pivot table in Excel on Mac](https://www.lazur.app/how-to/make-a-pivot-table-in-excel) and [How to use XLOOKUP in Excel on Mac](https://www.lazur.app/how-to/use-xlookup-in-excel).

## Shortcuts

- Expand or minimize the ribbon: ⌘ ⌥ R

## If it does not work

- **Goal Seek is missing from the Data tab** Check that you are in the Excel desktop app, not Excel for the web. Confirm you use Excel for Microsoft 365, 2024, or 2021 for Mac. If the ribbon is collapsed, press ⌘ ⌥ R to expand or minimize it.
- **Excel says it may not have found a solution** Check that the Set cell formula refers to the By changing cell. Then test a target you can reach by hand. If that test works, the original target was out of reach.
- **The Set cell never matches the target** The formula may not read the input cell. Trace the chain. Also confirm that Set cell holds a formula, not a typed number.
- **The answer is a little off the target** Goal Seek results are approximate. Check the Set cell, then decide whether the gap matters for your use. Run the command again if the gap is too large.
- **The model needs two or more inputs** Goal Seek adjusts one input. Microsoft points to the Solver add-in for multiple inputs. Solver also runs only in the desktop app.
- **Your menu does not match the steps** A community answer places What-If Analysis under a Forecast group, and Microsoft's Mac page does not. Look for the labels, check your build, and compare it with the newest build, 16.114.3.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where is What-If Analysis, and walk me through Goal Seek?”: Lazur draws a circle and a label around What-If Analysis on your screen. Ask for the full walkthrough, and it guides you one click at a time, waiting for each click. (Walks you through it)

## FAQ

### Where is Goal Seek in Excel on Mac?

Open the workbook in the Excel desktop app, click the Data tab, click What-If Analysis, then click Goal Seek. Microsoft's Mac steps follow this path exactly. A community answer also places the command under a Forecast group, so look for the label if the layout differs.

### Is there a keyboard shortcut for Goal Seek on Mac?

Not that Microsoft lists. Microsoft's Mac keyboard shortcut list has no shortcut for What-If Analysis, Goal Seek, or the Data tab. Use your mouse or trackpad to reach the command.

### Can I use Goal Seek in Excel for the web?

Not according to a Microsoft Q&A community answer, which says Goal Seek is not available in Excel for the web. Open the file in the desktop app through Open in Excel. Microsoft also says iteration settings need the desktop app.

### Which Excel versions on Mac include Goal Seek?

Microsoft's Goal Seek page lists Excel for Microsoft 365 for Mac, Excel 2024 for Mac, and Excel 2021 for Mac. Check your build against Microsoft's release notes if your menus look different from the steps.

### Can Goal Seek change two cells at once?

No. Microsoft's page says Goal Seek works with only one variable input value. For more inputs, Microsoft points to the Solver add-in.

### Does Goal Seek give an exact answer?

Not always. Results are approximate, so check the Set cell after you run it. Compare the value in the Set cell with your target before you rely on the input Goal Seek found.

### Why does the Set cell need a formula?

Goal Seek works by changing an input and watching a formula react to it. Microsoft describes Set cell as the cell with the formula to resolve. A typed number has no link to the input, so there is nothing for Goal Seek to move.

### What macOS do I need to keep getting Office updates?

Microsoft says a minimum of macOS 14 (Sonoma) is required to receive updates to Microsoft 365 and Office apps. Older macOS versions still run Office, but they stop receiving updates, including security updates.

## Sources

1. [Use Goal Seek to find the result you want by adjusting an input value](https://support.microsoft.com/en-us/excel/use-goal-seek-to-find-the-result-you-want-by-adjusting-an-input-value), Microsoft Support, checked 2026-11-09
2. [How can I access goal seek from my macbook excel online?](https://learn.microsoft.com/en-us/answers/questions/5282398/how-can-i-access-goal-seek-from-my-macbook-excel-o), Microsoft Q&A (community answer), checked 2026-11-09
3. [Keyboard shortcuts in Excel](https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f), Microsoft Support, checked 2026-11-09
4. [Change formula recalculation, iteration, or precision in Excel](https://support.microsoft.com/en-us/excel/change-formula-recalculation-iteration-or-precision-in-excel), Microsoft Support, checked 2026-11-09
5. [Release notes for Office for Mac](https://learn.microsoft.com/en-us/officeupdates/release-notes-office-for-mac), Microsoft Learn, checked 2026-11-09