Exceljet

Quick, clean, and to the point

Select table

Windows shortcut 
CtrlA
Mac shortcut 
A

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.
Because tables support structured references, you can learn a lot about a table with simple formulas. In this video, we'll look at some formulas you can use to query a table.
What is an Excel Table? This video provides an introduction to Excel Tables.
In this lesson, we cover shortcuts you can use when working with Excel Tables.
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 update data in a pivot chart. Like pivot tables, pivot charts require a refresh.