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 move a custom table style into another Excel workbook.
In this video we'll look at how to apply conditional formatting to a table with a formula.
In this video, we look at how to configure a slicer to control more than one pivot table at once.
In this video, we look at how to use VLOOKUP to lookup values in an Excel Table.
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.
