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 lesson we look at how to generate an expiration date in the future, how to calculate "days remaining," and how to highlight dates that are "expired" or "expiring soon" with conditional formatting.
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.
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 video, we'll look at how to use the SUMIFS function with an Excel table, with a side-by-side comparison without a table.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.