Microsoft Office Tutorials and References
In Depth Information
Deleting rows or columns
When you insert a new column, the Header Row displays a generic description, such
as Column1, Column2, and so on. Typically, you’fill want to change these names to more
descriptive labels. Just select the cell, type new text, and press Enter.
Deleting rows or columns
To delete a row (or column) in a table, select any cell in the row (or column) to be deleted.
To delete multiple rows or columns, select a range of cells. Then right-click and choose
Delete Table Rows (or Delete Table Columns).
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, Drag the table to its new location on the current sheet or another
visible worksheet. It may be easier to cut and paste to move a table to another worksheet or workbook. Press Ctrl+A
twice to select the entire table, then press Ctrl+X to cut it. Display the destination worksheet, click in the upper-left
corner of the range where you want to paste the table, and press Ctrl+V.
Excel Remembers
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.
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.
By default, a Total Row displays the sum of the values in a column of numbers. In some
cases, you’fill want a different type of summary formula. (For more information about
formulas, including the use of formulas in a table column, see Chapter 15.) When you select
a cell in the Total Row, a drop-down arrow appears in the cell. Click the arrow, and you can
select from a number of other summary formulas (see Figure 19.5):
Search JabSto ::




Custom Search