Microsoft Office Tutorials and References
In Depth Information
Select Table Data
Select Table
Data
If you want to work with part of a table, you first
need to select that part of the table. For example, if
you want to apply a format to an entire column or
copy an entire row, you first need to select that
column or row.
The normal range-selection techniques in Excel often
do not work well with a table. For example, selecting
an entire worksheet column or row does not work
because no table uses up an entire worksheet column
or row. Instead, Excel provides several tools for
selecting a table column (just the data or the data
and the header), a table row, or the entire table.
Select Table Data
Select a Table Column
1 Click any cell in the column
you want to select.
2 Right-click the selected cell.
3 Click Select .
4 Click Table Column Data .
Excel selects all the column’s
data cells.
Select a Table Column and
Header
1 Click any cell in the column
you want to select.
2 Right-click the selected cell.
3 Click Select .
4 Click Entire Table Column .
Excel selects the column’s
data and header.
Search JabSto ::




Custom Search