Banjo For Dummies
Book image
Explore Book Buy On Amazon

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.

About This Article

This article is from the book:

About the book author:

Bill Evans has helped thousands of people to play the five-string banjo through his instructional workshops, music camps, DVDs, books, and recordings. He has performed on stages all over the world, his recordings have topped folk and bluegrass charts, and he has mentored many of today's top young professional players. Bill shares the shortcuts and secrets he has developed in more than 35 years of teaching to help all banjo players sound their best.

This article can be found in the category: