How to Edit Cell Content in Excel 2013 - dummies

By Bill Evans

You can edit the content of a cell in an Excel 2013 worksheet either in the cell itself or in the Formula bar. If you need to edit the content in a cell, you can

  • Click the cell to select it, and then click the cell again to move the insertion point into it. Edit just as you would in any text program.

  • Click the cell to select it and then type a new entry to replace the old one.

If you decide you don’t want the text you typed in a particular cell, you can get rid of it in several ways:

  • Select the cell; then right-click the cell and choose Clear Contents from the menu that appears.

  • Select the cell; then choose Home→Clear→Clear Contents.

  • Select the cell, press the spacebar, and then press Enter. This technically doesn’t clear the cell’s content, but it replaces it with a space.

  • Select the cell and press the Delete key.

Don’t confuse the Delete key on the keyboard (which issues the Clear command) with the Delete command on the Ribbon. The Delete command doesn’t clear the cell content; instead, it removes the entire cell.

And, don’t confuse Clear with Cut, either. The Cut command works in conjunction with the Clipboard. Cut moves the content to the Clipboard, and you can then paste it somewhere else. Excel, however, differs from other applications in the way this command works: Using Cut doesn’t immediately remove the content.

Instead, Excel puts a flashing dotted box around the content and waits for you to reposition the cell cursor and issue the Paste command. If you do something else in the interim, the cut-and-paste operation is canceled, and the content that you cut remains in its original location.