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:
- First time: selects table data
- Second time: selects table data + table header
- 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.
