Start Learning
Data Windows only

Toggle filters on the selected header row

Ctrl Shift L

Quickly adds or removes filter dropdowns without going through the ribbon.

More Data Shortcuts

  • Ctrl+T — Convert the selected range into a Table
  • Cmd+T — Convert the selected range into a Table
  • Ctrl+Shift+; — Insert the current time as a static value
  • Ctrl+; — Insert today's date as a static value
  • Cmd+; — Insert today's date as a static value
  • Ctrl+Shift+Space — Select the current region (or the whole sheet if pressed twice)

View All Shortcuts