Select rows and columns in an Excel table

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.

Table column selection arrow

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.

Table row selection arrow

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.

Table corner selection arrow

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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×