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
222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.
Shade groups of rows with conditional formatting
In this video, we'll look at how to use conditional formatting to shade alternating groups of rows - groups of 3 rows, groups of 4 rows, and so on.
How to copy a table style to another file
In this video, we'll look at how to move a custom table style into another Excel workbook.
How to use a slicer with multiple pivot tables
In this video, we look at how to configure a slicer to control more than one pivot table at once.
How to use VLOOKUP with a table
In this video, we look at how to use VLOOKUP to lookup values in an Excel Table.
10 pivot table problems and easy fixes
Pivot tables are very easy to create, but they still present challenges. In this video, we look at how to identify and fix 10 common pivot table problems.