Alt W S H on Mac: Headings in Excel

To run Headings with Alt W S H in Excel on a Mac, install LightningXL, tap Option, then type W, S, H. The same keys as Windows, with the same result.

⌥Option
WView
SShow (collapsed group)
HHeadings

Step by step

  1. Install LightningXL

    Download LightningXL, then follow the instructions. Setup takes about two minutes.

  2. Select what to act on

    Click a cell, or select the range the command should apply to.

  3. Tap Option, then type W S H

    Tap ⌥ on its own to show the keytips, then W for View, S for Show (collapsed group), H for Headings.

What Alt W S H does

Headings sits under View › Show (collapsed group) on the Excel ribbon. On Windows, Alt W S H runs it from the keyboard. Excel for Mac has the same ribbon but no Alt key, so without LightningXL you click through View › Show (collapsed group) › Headings instead.

Related shortcuts

The rest of the Show (collapsed group) menu in Excel:

Every Windows shortcut you know, on your Mac

Alt keytips for the Excel, Word and PowerPoint ribbons, plus 100+ of the most common modeling shortcuts.

Download Now

7-day free trial · No card required