Add the Clear Formats option to Quick Access toolbar This might be especially useful if you receive many Excel files from your colleagues or clients and their formatting prevents you from making the data look the way you want. If you want to have a one-click tool to remove formatting in Excel, you can add the Clear Formats option to the Quick Access toolbar or Excel ribbon.
IFTEXT IN CUSTOM FORMATTING EXCEL HOW TO
How to make the Clear Formats option accessible in a click