Modifying Cell Contents

After you enter a value or text into a cell, you can modify it in several ways:

  • Erase the cell’s contents

  • Replace the cell’s contents with something else

  • Edit the cell’s contents

Erasing the contents of a cell

To erase the contents of a cell, just click the cell and press Delete. To erase more than one cell, select all the cells that you want to erase and then press Delete. Pressing Delete removes the cell’s contents but doesn’t remove any formatting (such as bold, italic, or a different number format) that you may have applied to the cell.

For more control over what gets deleted, you can choose Home Editing Clear. This command’s drop-down list has four choices:

  • Clear All: Clears everything from the cell

  • Clear Formats: Clears only the formatting and leaves the value, text, or formula

  • Clear Contents: Clears only the cell’s contents and leaves the formatting

  • Clear Comments: Clears the comment (if one exists) attached to the cell

Note

Clearing formats doesn’t clear the background colors in a range that has been designated as a table, unless you’ve replace the table style background colors manually.

Replacing the contents of a cell

To replace the contents of a cell with something else, just activate the cell and type your new entry, which replaces the previous contents. ...

Get Office 2007 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.