How To Clear The Formatting In A Cell In Excel

Premium Excel Course Now Available!

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!

Quickly Clear all Formatting in Excel

Add to Favorites Favorited

How to remove all formatting from cells at once in Excel.

This includes removing any and all types of formatting but leaving all data intact inside the cell. You can do this to one or many cells and it's quite simple.

Steps to Quickly Remove Formatting in Excel

Select the data:
Go to the Home tab and on the right side click the white eraser and select the Clear Formats option(you can also use the keyboard shortcut Alt + E + A + F and this shortcut also works in Excel 2003):
Now, your data is format-free:

This is sooooo much faster than removing each formatting element individually and, oddly enough, very few people know about this feature and, therefore, many waste hours each year individually removing formatting elements from cells in Excel.

Keyboard Shortcut to Remove All Formatting from Cells in Excel

Alt + E + A + F

This will work in every version of Excel.

Question? Ask it in our Excel Forum

Our Excel Courses

Professional Input Forms in Excel

Skill Level: All Levels
|
5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel (Multiple Methods)

Skill Level: All Levels
|
2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Subscribe for Weekly Tutorials

BONUS: subscribe now to download our Top Tutorials Ebook!