- Entering Data and Making Changes
- Entering Data
- Editing and Deleting Existing Data
- Zooming Into Your Data
- Undoing and Redoing Changes
- Copying and Pasting Data
- Freezing Rows and Columns
- Splitting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Moving Data
- Finding Data
- Replacing Data
- Applying a Data Filter
- Sorting Data
- Adding and Managing Cell Comments
This chapter is from the book
This chapter is from the book
This chapter is from the book
Deleting Cells
As you work with worksheets, you might find that data needs to be eliminated to keep the worksheet up to date. You can easily delete extraneous cells and shift existing cells to their correct locations.
)
Select the cell or cells that need to be deleted.
Right-click and choose the Delete option.
In the Delete dialog box, choose whether you want to shift existing cells left or up to fill the empty space left by the
deleted cells. Press the OK button.
Observe that Excel has deleted the specified cells.
Caution: Watch for Misaligned Data When Deleting Cells
Be aware that when you delete a cell, the cells below or to the right of that cell shift (one row up or one column to the left). Be careful that when this happens, your data table does not become misaligned. If it does, you may want to use the Delete Rows or Delete Columns options (explained later in this chapter).