Coming Soon

Alt H L T T on Mac: Top 10 Items in Excel

To run Top 10 Items with Alt H L T T in Excel on a Mac, install LightningXL, tap Option, then type H, L, T, T. The same keys as Windows, with the same result.

⌥Option
HHome
LConditional Formatting
TTop/Bottom Rules
TTop 10 Items

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 H L T T

    Tap ⌥ on its own to show the key tips, then H for Home, L for Conditional Formatting, T for Top/Bottom Rules, T for Top 10 Items.

What Alt H L T T does

Top 10 Items sits under Home › Conditional Formatting › Top/Bottom Rules on the Excel ribbon. On Windows, Alt H L T T runs it from the keyboard. Excel for Mac has the same ribbon but no Alt key, so without LightningXL you click through Home › Conditional Formatting › Top/Bottom Rules › Top 10 Items instead.

Related shortcuts

The rest of the Top/Bottom Rules menu in Excel:

Every Windows shortcut you know, on your Mac

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

Coming Soon

7-day free trial · No card required