Microsoft Office Tutorials and References
In Depth Information
Data entered in the new row 10
total values are
Note that Excel automatically inserts the formula =E10*F10 into cell G10 for you. Excel rec-
ognizes that you are inserting a new set of values into a list of values and assumes that you
intend to use the same formulas for the new order that you used for the previous ones. Also
note that the calculations of the total quantity of items ordered and the total revenue from
those orders have been updated. The functions now calculate the sums in the cell ranges
F6:F10 and G6:G10. You’ll learn more about how such formulas are automatically adjusted
by Excel in the next tutorial.
Deleting a Row or Column
Sandra has also learned that David Wu has canceled his co-op order. You have two
options for removing data from a worksheet. If you simply want to erase the contents of a
cell, you can clear the cell, without actually removing the cell from the worksheet. If you
want to remove not only the contents of the cells from the worksheet, but also the cells
themselves, you can delete a cell range, and Excel then shifts the contents of the adjacent
cells into the location of the deleted cells.
To clear the contents of a cell or range of cells, you select the range and then select the
Clear command on the Edit menu or on the shortcut menu that you display by right-
clicking the selection. Pressing the Delete key on the keyboard also clears the contents of
the selected cells, without removing the cells themselves. To delete cells and their con-
tents, you select the range and then choose the Delete command on the Edit menu, or
right-click the selected cells, and click Delete on the shortcut menu. To adjust the adja-
cent cells, Excel opens the Delete Cells dialog box, which you can select to shift the
remaining cells left or up, or choose to delete the entire row.
Because David Wu has canceled his order, you’ll delete it from the worksheet.