Excel - Clear format or content
You can easily clear the format, content, or both in Excel. Suppose you have a table like below. But now you do not like the format, what can you do? 1. Select the data range that you want to clear. Then click Home > Clear , select Clear Formats 2. Then, all the formats are gone. What you see is the plain Excel content. 3. If you click Clear Content , all the content is gone. This function is same as pressing the " Delete " button on the keyboard. Learn format table by cell values using conditional formatting