Quick, clean, and to the point

Select table

Windows shortcut 
Mac shortcut 

This shortcut selects the data area of a table, when the cursor is in an Excel table. Behavior changes as the shortcut is used more than once:

  1. First time: selects table data
  2. Second time: selects table data + table header
  3. Third time: selects entire worksheet

Related videos

The videos below demonstrate this shortcut.
In this video, we'll look at how to use the SUMIFS function with an Excel table, with a side-by-side comparison without a table.
In this video we'll look at how to apply conditional formatting to a table with a formula.
In this video, we'll look at how to update data in a pivot chart. Like pivot tables, pivot charts require a refresh.
In this lesson we look at how to generate an expiration date in the future, how to calculate "days remaining," and how to highlight dates that are "expired" or "expiring soon" with conditional formatting.
In this video, we'll look at how to move a custom table style into another Excel workbook.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.