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.
|
United States
Email this link
Printer-Friendly Version
Share
