How to make the Clear Formats option accessible in a click To clear formats in non-adjacent cells or ranges, select the first cell or range, press and hold the CTRL key while selecting other cells or ranges.To remove formatting from a whole column or row, click the column or row heading to select it.To clear out formatting from all cells on a worksheet, select the entire sheet by pressing Ctrl+A or by clicking the Select All button at the top-left corner of the worksheet, and then click Clear Formats.With this Excel Clear Formatting feature, you can easily remove formats not only from a single cell, but also from an entire row, column or worksheet.
This will erase all cell formatting (including conditional formatting, number formats, fonts, colors, borders, etc.) but keep the cell contents.
In other situations, however, you may want to highlight other data, and for this, you will need to remove the current format first. When working with large Excel worksheets, it's a common practice to apply different formatting options to make data relevant to a particular situation stand out. This short tutorial shows a couple of quick ways to remove formatting in Excel worksheets.