How to clear formatting in Excel

How to clear formatting in Excel

You might need to clear all the cells' formats so that they can be interpreted as plain text. Here we tell you how to quickly clear any batch of cells depending on your needs.

excel-sheet">To clear formatting in Excel:

  • Select all the cells you need (Press Ctrl + A to select all the cells).
  • On the Home tab, in the Editing group, click the arrow next to the Clear button, and then do one of the following:

    • To clear all contents, formats, and comments that are contained in the selected cells, click Clear All.

    • To clear only the formats that are applied to the selected cells, click Clear Formats.

    • To clear only the contents in the selected cells, leaving any formats and comments in place, click Clear Contents.

    • To clear any comments or notes that are attached to the selected cells, click Clear Comments and Notes.

    • To clear any hyperlinks that are attached to the selected cells, select Clear Hyperlinks.

All of the data in your cells will now be in plain text.

any more questions about excel? check out our forum!
Subject Replies
How to calculate positions(1st,2nd,3rd...) in Excel 4
Unable to change date format in Excel 39
How to convert number into text in Excel 9
Convert number to spelling 28
Date formatting in dd/mm/yyyy 11

Excel