Excel.Tips.Net: Clearing and Deleting Cells

March 16, 2012 by in Excel Tips

By Allen Wyatt for Excel.Tips.Net

Clearing and Deleting Cells in Microsoft Excel

As you are editing your Excel workbooks, one of the most common actions to take is to clear or delete cells. Clearing cells means erasing everything within them, whereas deleting actually deletes the entire cell (or cells). This may sound like an odd distinction, but it is not really. If you compare the cells in your worksheet to paper cups, you can either remove a cup entirely (deleting the cup) or simply remove any contents from the cup (clearing the cup). When you delete a cell, the other cells around that cell move to fill where the cell used to be.

To clear the contents of cells you have selected, display the Home tab of the ribbon and click the Clear tool in the Editing group. When you do, you will see a submenu asking what you want to clear. Your choices allow you to clear any of the following:

  • Clear All. Everything related to the cell except the cell itself.
  • Clear Formats. Any formatting applied to the cell.
  • Clear Contents. The information in the cell. Any formatting and comments remain in place.
  • Clear Comments. The comments attached to the cell.
  • Article Continued Here

    Excel Tips

    About Excel Tips

    The tips and ideas from ExcelRibbon.Tips.Net are designed specifically for users of Excel starting with Excel 2007. You'll find just about everything you need to become productive with the program right away. (If you need help with other versions of Excel, visit the ExcelTips site.)

    Leave a Reply

    Your email address will not be published. Required fields are marked *


    You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

    Scan with PC Matic

    Sign up for our FREE Newsletter

    Our weekly newsletter is packed with computer tips & tricks.
    As a bonus, receive monthly emails with exclusive offers.

    Which device is the most important to you?

    View Results

    Loading ... Loading ...


    Contributors