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.
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 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.
