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 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 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 show you how some of Excel's shortcuts for selecting cells.
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.
