Alt + N + S + W in Google Sheets (Win/Loss Sparkline)
Adds an in-cell win/loss chart that shows positive and negative values as up and down bars.
Add to Chrome (14 Days Free)In Excel: Insert tab, Sparklines. In ShortieCuts' key-tip menu: "Win/Loss Sparkline".
What Alt + N + S + W Does in Excel
Adds an in-cell win/loss chart that shows positive and negative values as up and down bars.
How to Use Alt + N + S + W 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 N, S, then W. ShortieCuts runs Win/Loss Sparkline, just like Excel.
ShortieCuts types a starter win/loss SPARKLINE formula into the cell for you to point at your data.
Without an extension: Google Sheets doesn't support Excel's Alt key-tips, so Alt + N + S + W won't run Win/Loss Sparkline on its own.
Related Shortcuts
| Keys | Shortcut |
|---|---|
| Alt NSL | Line SparklineAdds a tiny in-cell line chart that summarizes a row or column of numbers. |
| Alt NSO | Column SparklineAdds a tiny in-cell column chart for a row or column of numbers. |
| Alt NV | PivotTableStarts a new pivot table from the selected data. |
| Alt NR | Recommended ChartsStarts a chart from the selected data. |
| Alt NC1 | Column ChartInserts a column chart from the selected data. |
| Alt NN1 | Line ChartInserts a line chart from the selected data. |
| Alt NQ | Pie ChartInserts a pie chart from the selected data. |
| Alt ND | Scatter ChartInserts a scatter (XY) chart from the selected data. |
FAQ
Does Alt + N + S + W work in Google Sheets?
Not on its own. Google Sheets doesn't have Excel's ribbon key-tips, so typing Alt + N + S + W won't run Win/Loss Sparkline. With the ShortieCuts Chrome extension installed, Alt + N + S + W works in Google Sheets the same way it does in Excel.
What does Alt + N + S + W do in Excel?
Win/Loss Sparkline. Adds an in-cell win/loss chart that shows positive and negative values as up and down bars.
How do I use Alt + N + S + W on a Mac?
With ShortieCuts, press Option instead of Alt, then N, then S, then W: Option + N + S + W. 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.