Chapter 5: Introducing Tables
107
Or, you can use these steps to move a table to different worksheet or workbook:- Press Ctrl+A twice to select the entire table.
- Press Ctrl+X to cut the selected cells.
- Activate the new worksheet and select the upper-left cell for the table.
- Press Ctrl+V to paste the table.
Setting table options ................................................................................................
The Table Style Options group of the Table Tools ➪ Design tab contains several check boxes that
determine whether various elements of the table are displayed, and whether some formatting
options are in effect:l (^) Header Row: Toggles the display of the Header Row.
l Total Row: Toggles the display of the Total Row.
l (^) First Column: Toggles special formatting for the first column. Depending on the table
style used, this command might have no effect.
l (^) Last Column: Toggles special formatting for the last column. Depending on the table
style used, this command might have no effect.
l (^) Banded Rows: Toggles the display of banded (alternating color) rows.
l Banded Columns: Toggles the display of banded columns.
Working with the Total Row ...................................................................................
The Total Row in a table contains formulas that summarize the information in the columns. When
you create a table, the Total Row isn’t turned on. To display the Total Row, choose Table Tools ➪
Design ➪ Table Style Options and put a check mark next to Total Row.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 valida-
tion, and so on. And if you create a chart using the data in a table, the chart will be extended auto-
matically if you add new data to the table. Those who have used versions prior to Excel 2007 will
appreciate this feature the most.Excel Remembers