Alt + H + S + O in Google Sheets (Sort Z to A)
Sorts the selected data in descending order: Z to A, or largest to smallest.
Add to Chrome (14 Days Free)In Excel: Home tab, Sort & Filter. In ShortieCuts' key-tip menu: "Z to A (High to Low)".
What Alt + H + S + O Does in Excel
Sorts the selected data in descending order: Z to A, or largest to smallest.
How to Use Alt + H + S + O 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 H, S, then O. ShortieCuts runs Sort Z to A, just like Excel.
Without an extension: Google Sheets doesn't support Excel's Alt key-tips, so Alt + H + S + O won't run Sort Z to A on its own.
Related Shortcuts
| Keys | Shortcut |
|---|---|
| Alt HSS | Sort A to ZSorts the selected data in ascending order: A to Z, or smallest to largest. |
| Alt HSU | Custom SortOpens the full sort dialog to sort by several columns at once. |
| Alt HSF | FilterTurns filter drop-downs on or off for the current data range. |
| Alt HSC | Clear FilterClears the filter criteria so every row shows again. |
| Alt HSY | Reapply FilterReapplies the current filter and sort after the data has changed. |
| Alt HVV | Paste ValuesPastes only the values of the copied cells. |
| Alt HVF | Paste FormulasPastes the copied formulas without bringing over the source cells' formatting. |
| Alt HVT | Paste TransposePastes the copied range with rows and columns swapped, so a row of headers becomes a column and vice versa. |
FAQ
Does Alt + H + S + O work in Google Sheets?
Not on its own. Google Sheets doesn't have Excel's ribbon key-tips, so typing Alt + H + S + O won't run Sort Z to A. With the ShortieCuts Chrome extension installed, Alt + H + S + O works in Google Sheets the same way it does in Excel.
What does Alt + H + S + O do in Excel?
Sort Z to A. Sorts the selected data in descending order: Z to A, or largest to smallest.
How do I use Alt + H + S + O on a Mac?
With ShortieCuts, press Option instead of Alt, then H, then S, then O: Option + H + S + O. 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.