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 look at how to use VLOOKUP to lookup values in an Excel Table.
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.
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.
In this video, we look at how to make conditional formatting variable, so that you can change how formatting is applied without editing a rule. This elegant technique helps you build killer spreadsheets that are fun to use.
In this video, we'll look at how to make a custom table style the default table style in new workbooks.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
