Alt + A + W + G in Google Sheets (Goal Seek)
Finds the input value that makes a formula return the result you want, for example the price that gets a model to a target IRR.
Add to Chrome (14 Days Free)In Excel: Data tab, Data Tools. In ShortieCuts' key-tip menu: "Goal Seek".
What Alt + A + W + G Does in Excel
Finds the input value that makes a formula return the result you want, for example the price that gets a model to a target IRR.
How to Use Alt + A + W + G in Google Sheets
- Add the ShortieCuts extension to Chrome and open any Google Sheet.
- Select the cells you want to work on (if the command needs a selection).
- Press Alt (or Option on Mac). Excel-style key-tips appear over the sheet.
- Press A, W, then G. ShortieCuts runs Goal Seek, just like Excel.
Google Sheets has no built-in Goal Seek. ShortieCuts adds one with the same three boxes as Excel: Set Cell, To Value and By Changing Cell.
Without an extension: Google Sheets doesn't support Excel's Alt key-tips, so Alt + A + W + G won't run Goal Seek on its own.
Related Shortcuts
| Keys | Shortcut |
|---|---|
| Alt ASA | Sort AscendingSorts the current data range from A to Z or smallest to largest, from Excel's Data tab. |
| Alt ASD | Sort DescendingSorts the current data range from Z to A or largest to smallest. |
| Alt ASS | SortOpens the full sort dialog with multiple sort levels. |
| Alt AT | FilterTurns filter drop-downs on for the current data range, from Excel's Data tab. |
| Alt AC | Clear FilterClears all filter criteria on the sheet. |
| Alt AE | Text to ColumnsSplits the text in one column into several columns, for example by comma or space. |
| Alt AM | Remove DuplicatesDeletes duplicate rows from the selected data, keeping the first of each. |
| Alt AVV | Data ValidationOpens data validation so you can restrict what can be typed into a cell, for example a drop-down list. |
FAQ
Does Alt + A + W + G work in Google Sheets?
Not on its own. Google Sheets doesn't have Excel's ribbon key-tips, so typing Alt + A + W + G won't run Goal Seek. With the ShortieCuts Chrome extension installed, Alt + A + W + G works in Google Sheets the same way it does in Excel.
What does Alt + A + W + G do in Excel?
Goal Seek. Finds the input value that makes a formula return the result you want, for example the price that gets a model to a target IRR.
How do I use Alt + A + W + G on a Mac?
With ShortieCuts, press Option instead of Alt, then A, then W, then G: Option + A + W + G. The same key-tips appear as on Windows.
Is ShortieCuts free?
ShortieCuts has a free 14-day trial with no credit card needed. After the trial, Pro is $7.99 a month or $69.99 a year.