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.
In this video, we'll look at how to make a custom table style the default table style in new workbooks.
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.
In this lesson, we cover shortcuts you can use when working with Excel Tables.
In this video, we'll look at how to create a pie chart in Excel. Pie charts show a "part to whole" relationship, and they work best with a limited number of categories.
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.