Microsoft Office Tutorials and References
In Depth Information
Deleting and Clearing a Row or Column
To insert the new row:
1. Click the row 2 heading. The entire second row is selected.
2. In the Cells group on the Home tab, click the Insert button. A new row 2 is
inserted, and the remaining rows shift down.
3. Enter the new customer order shown in Figure 1-13 into row 2.
Figure 1-13
New row inserted into the worksheet
insert ed row
existing rows are
shifted down
Deleting and Clearing a Row or Column
You can remove data in two ways: clearing and deleting. Clearing data from a worksheet
removes the data, leaving blank cells where the data had been. Deleting data from the
worksheet removes both the data and the cells. When a cell is deleted, the remaining
cells in the worksheet shift into the deleted location. For example, when you delete a
column, the columns to the right shift left to fi ll the vacated space. Similarly, the rows
below a deleted row shift up to fi ll the vacated space. Note that pressing the Delete key
does not delete the selected row or column; instead, it clears the contents, leaving the
row or column in place.
Gregory Dawes just canceled his order. Amanda wants you to remove this order from
the worksheet. You’ll fi rst clear Gregory Dawes’s data from the worksheet and then delete
the row that contained the data. Usually, you would do this in one step by simply
deleting the row, but this will highlight the difference between clearing and deleting.
To clear and delete the third row:
1. Click the row 3 heading. The entire row 3 with Gregory Dawes’s order is selected.
2. Right-click the row 3 heading, and then click Clear Contents on the
shortcut menu. Excel clears the values in the third row, but leaves the blank row in
that space.
3. Verify that the third row is still selected.
4. In the Cells group on the Home tab, click the Delete button. The third row is
deleted, and the rows below it shift up. Only four customer orders remain in the
worksheet.
Search JabSto ::




Custom Search