Clearing Cell Contents

Clearing Cell Contents

You can clear a cell to remove its contents. Clearing a cell does not remove the cell from the worksheet; it just removes from the cell whatever elements you specify: data, comments (also called cell notes), or formatting instructions. When clearing a cell, you must specify whether to remove one, two, or three of these elements from the selected cell or range.

Clear the Contents of a Cell

Select the cell or range you want to clear.

Click the right mouse button, and then click Clear Contents on the shortcut menu, or press Delete.

Clear Cell Contents, Formatting, and Comments

Select the cell or range you want to clear.

Click the Edit menu, and then point to Clear.

Click All.

See Also

See " Inserting Comments " on page 41 for information on inserting comments.