Search all of Office.com
 
Support / Excel / Excel 2007 Help and How-to / Worksheet and Excel table basics / Using Excel tables
 
 

Select rows and columns in an Excel table

Applies to: Microsoft Office Excel 2007

 

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.