There’s very little that’s more frustrating than creating a large worksheet and discovering that you forgot to enter data in a few cells. If you’re new to Excel, you might be tempted to cut the existing cells and paste them a few cells below their current location to make room for the new data. But that’s too much like work; there’s an easier way to insert a few cells to give you the room you need. Similarly, it’s not that difficult to move a group of cells to a new location in your worksheet or to delete a group of cells that contains data you entered by accident. After you insert or delete cells, you can choose how to move existing cells to fill in the space left by the deleted cells or to make room for the new cells.
Select the option button representing how you want the remaining cells to fill in the deleted space.
Because Excel doesn’t highlight an entire row or column when you click a single cell, you can be a bit inaccurate if you attempt to delete a row or column by clicking a cell and then clicking the Entire Row or Entire Column option button in the Delete dialog box. It’s better to follow the procedure listed in the following section, where you click the row or column header, so you can see the entire row or column to be deleted.
3.15.206.25