Microsoft Office Tutorials and References
In Depth Information
Working with Tables
When you do something with a complete column in a table, Excel remembers that and extends
that “something” to all new entries added to that column. For example, if you apply currency
formatting to a column and then add a new row, Excel applies currency formatting to the new
value in that column.
The same thing applies to other operations, such as conditional formatting, cell protection, data
validation, and so on. And if you create a chart using the data in a table, the chart will be
extended automatically if you add new data to the table. Those who have used a previous
version of Excel will appreciate this feature the most.
Moving a table
To move a table to a new location in the same worksheet, move the mouse pointer to any of its
borders. When the mouse pointer turns into a cross with four arrows, click and drag the table to
its new location.
To move a table to a different worksheet (in the same workbook or in a different workbook), do
1. Select any cell in the table and press Ctrl+A twice to select the entire table.
2. Press Ctrl+X to cut the selected cells.
3. Activate the new worksheet and select the upper-left cell for the table.
4. Press Ctrl+V to paste the table.
Setting table style options
The Table Tools
Table Style Options group contains several check boxes that
determine whether various elements of the table are displayed and also whether some formatting
options are in effect:
h Header Row: Toggles the display of the Header row
h Total Row: Toggles the display of the Total row
h First Column: Toggles special formatting for the first column
h Last Column: Toggles special formatting for the last column
h Banded Rows: Toggles the display of banded (alternating color) rows
h Banded Columns: Toggles the display of banded (alternating color) columns