All shortcuts
Sensitivity Table (Data Table) in Google Sheets
ProWindows
Alt→A→W→T
Mac
Option→A→W→T
Every finance model ends with a sensitivity table: how does the output move as one or two inputs change? Excel generates these with Data > What-If Analysis > Data Table (Alt A W T). Google Sheets simply doesn’t have the feature.
XLKeys adds it. Press Alt A W T, pick your output cell and the input(s) to vary, give the ranges, and XLKeys builds the full sensitivity grid in your sheet.
Excel vs. Google Sheets vs. XLKeys
| Where | Shortcut |
|---|---|
| Excel | Alt→A→W→T (Data Table) |
| Google Sheets (native) | No keyboard shortcut |
| Google Sheets + XLKeys | Alt→A→W→T |
Google Sheets has no equivalent of Excel’s What-If Data Table — people fake it with fragile formula grids.
How to use it
- Press Alt, release it, then type A, W, T.
- Choose the output cell (the formula you want to sensitize).
- Pick one or two input cells and the range of values for each.
- Run it — XLKeys writes the populated sensitivity table into your sheet.
Frequently asked questions
Related shortcuts
Make Google Sheets feel like Excel
Install XLKeys to use sensitivity table (data table) and 150+ other Excel-style shortcuts, Alt-key sequences, formula auditing, Goal Seek, and Sensitivity Tables in Google Sheets.