Clear All Formatting in Excel 13

I believe most of us have tried to clear the content of a specific cell in Excel. We press the Delete button on our keyboard and the content of the cell has been cleared. What happens though, when we want to clear the format that we might have applied on a cell or on an area of cells? What happens when we want to clear a Comment or a Hyperlink that we have inserted to a cell or on any area of cells? That is where the Clear command comes in use. All we have to do is to follow the steps described below.

Selected Cells

First of all we select the cell or the area of cells and then we select the Home tab and then from the area of the ribbon named Editing which is located at the right of the ribbon we select the arrow at the right of the Clear command as shown in the image below. Once the drop down menu appears we have available the following commands:

Home Tab - Editing Area

Clear All: If we select this command all the Formats, Contents, Comments, Hyperlinks will be cleared completely, meaning that the state of cells will become to their default, as when we first used editing them.

Clear All

Clear Formats: If we select this command only the Formatting of the cells will be cleared. Meaning that if we had formatted the cells with a different font, different size font, different font color, different color cell fill, different border, etc. will be restored to the default.

Clear Formats

Clear Contents: If we select this command the Contents of the cells will be cleared, meaning that whatever formatting that we may have applied to the cells will be remained and only the contents will be cleared.

Clear Contents

Clear Comments: If we select this command, the Comments that we may have inserted in a cell will be cleared.

Clear Comments

Clear Hyperlinks: If we select this command the Hyperlinks that we may have inserted in a cell will be cleared, meaning that the Hyperlink will be removed but the formatting that we have applied to the cell will still remain.

Clear Hyperlinks

Remove Hyperlinks: If we select this command the Hyperlinks that we have inserted to a cell will be removed as long with all the formatting that we might have applied to the cell.

Remove Hyperlinks

Below you can check out the video on how to use the Clear command in Excel 13.

Clear Formatting in Excel 13

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on March 14, 2014, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Clear All Formatting in Excel 13.

Comments are closed.