How to Clear Formatting in Excel (The Simplest Way)

How to Clear Formatting in Excel

Here we are with the simplest way how to clear formatting in Excel. If you’re working with a table that contains various font types, sizes or colours or other forms of formatting that you need to get rid of, Excel offers a very simple and comfortable way how to clear all formatting at once.

How to Clear Formatting in Excel - various font types, sizes or colours or other forms of formatting

Ready to start?

Would you rather watch this tutorial? Click the play button below!

How to Clear Formatting in Excel

To begin, select the area where you want to clear formatting.

How to Clear Formatting in Excel - select the area where you want to clear formatting

If needed, you can select the whole spreadsheet by clicking in the upper left corner.

How to Clear Formatting in Excel - select the whole spreadsheet

Then go to the Home tab where in the section Editing you can click on the option ‘Clear’.

How to Clear Formatting in Excel - go to the Home Tab
How to Clear Formatting in Excel - click on the option CLEAR

Now just click on ‘Clear Formats’ and that’s it!

How to Clear Formatting in Excel - clear formats

All formatting has been removed.

How to Clear Formatting in Excel - All formatting has been removed

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.