Selecting Table Areas
Moving among cells in a table works just like moving among cells in a normal range. One difference is when you use the Tab key. Pressing Tab moves to the cell to the right; when you reach the last column, pressing Tab again moves to the first cell in the next row.
When you move your mouse around in a table, you may notice that the pointer changes shapes. These shapes help you select various parts of the table.
To select an entire column:
Move the mouse to the top of a cell in the header row, and the mouse pointer changes to a down-pointing arrow. Click to select the data in the column. Click a second time to select the entire table column (including the header). You can also press Ctrl+spacebar (once or twice) to select a column.
To select an entire row:
Move the mouse to the left of a cell in the first column, and the mouse pointer changes to a right-pointing arrow. Click to select the entire table row. You can also press Shift+spacebar to select a table row.
To select the entire table:
Move the mouse to the upper-left part of the upper-left cell. When the mouse pointer turns into a diagonal arrow, click to select the data area of the table. Click a second time to select the entire table (including the Header Row and the Totals Row). You can also press Ctrl+A (once or twice) to select the entire table.
Right-clicking a cell in a table displays several selection options in the shortcut menu.
In this tutorial:
- Excel Table
- What is Table
- Create Tables
- Converting a Table to a Range
- Sorting Table Record
- Filtering Data in a Table
- Advanced Filter Command
- Working with the Total Row
- Applying a new style to a table
- Removing Duplicate Rows from a Table
- Selecting Table Areas
- Table Calculation
- Inserting, Moving and Deleting Table Rows and Columns