O'Reilly logo

Office 2007 Bible by Lisa A. Bucki, Gavin Powell, Michael R. Irwin, Peter G. Aitken, Michael R. Groh, Cary N. Prague, Faithe Wempen, Herb Tyson, John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required