1. Deleting the data and clearing the row.
Deleting Cells and Data in Excel 2007

In Microsoft Office Excel 2007, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options depending on your objective. Excel can perform two kinds of cell deletions in a worksheet: clearing cell data and deleting the cell.

Clearing cell contents

Clearing just deletes or empties the cell’s contents or formatting without removing the cell from the worksheet, which would alter the layout of the surrounding cells. To get rid of just the contents of a cell selection, just select the range of cells to be cleared and press the Delete key.
If you want to get rid of more than just the contents of a cell selection, like cell formatting or cell comments, select the cell(s) and follow these steps: 1. Click the Clear button (the one with the eraser) in the Editing group on the Ribbon’s Home tab. 2. Click one of the following options on the Clear drop-down menu: * Clear All gets rid of all formatting, notes, and entries in the cell selection. * Clear Formats deletes only the formatting from the cell selection without touching anything else. * Clear Contents deletes only the cell entries, just like pressing the Delete key. * Clear Comments removes the notes in the cell selection but leaves everything else intact.

Deleting cells, rows, or columns

Deleting gets rid of the whole kit and caboodle — cell structure along with all its contents and formatting. When you delete a cell (or an entire row or column), Excel has to shuffle the position of entries in the surrounding cells to plug up any gaps made by the demise.

To delete the actual cell selection rather than just clear out the contents, follow these steps: 1. Select the cells, rows, or columns you want to delete.