You can select cells and ranges in a table just like you would select them in a worksheet, but selecting table rows and columns is different from selecting worksheet rows and columns.
|
To select |
Do this |
|---|---|
|
A table column with or without table headers |
Click the top edge of the column header or the column in the table. The following selection arrow appears to indicate that clicking selects the column.
Note: Clicking the top edge once selects the table column data; clicking it twice selects the entire table column. You can also click anywhere in the table column, and then press CTRL+SPACEBAR, or you can click the first cell in the table column, and then press CTRL+SHIFT+DOWN ARROW. Note: Pressing CTRL+SPACEBAR once selects the table column data; pressing CTRL+SPACEBAR twice selects the entire table column. |
|
A table row |
Click the left border of the table row. The following selection arrow appears to indicate that clicking selects the row.
You can click the first cell in the table row, and then press CTRL+SHIFT+RIGHT ARROW. |
|
All table rows and columns |
Click the upper-left corner of the table. The following selection arrow appears to indicate that clicking selects the table data in the entire table.
Click the upper-left corner of the table twice to select the entire table, including the table headers. You can also click anywhere in the table, and then press CTRL+A to select the table data in the entire table, or you can click the top-left most cell in the table, and then press CTRL+SHIFT+END. Press CTRL+A twice to select the entire table, including the table headers. |
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.
See Also
Video: Create and format an Excel table
Total the data in an Excel table
Resize a table by adding or removing rows and columns
Filter data in a range or table
Using structured references with Excel tables
