Fastest Way to Remove All Formatting in Excel - Excel Quickie 57

Stop wasting time and follow this tip! This shows you the fastest and easiest way to remove all formatting from cells in Excel.

This Excel Quickie covers a great tip that removes all formatting from cells without harming or altering the data in the worksheet.

Types of formatting that this tip will remove:
- conditional formatting
- text formatting
- cell formatting
- number formatting
- colors, font's, and more

This little tip will save you a lot of time, I guarantee it!

I hope you enjoy this Excel Quickie!

#excel #tutorial #excelquickie

[downtownlife]

Exactly what I was looking for... I have no idea what this previous excel sheet author was thinking with random colored backgrounds and whited out cells... ALL GONE! Thanks!

[officerM]

so easy but I NEVER knew this! Thanks!

[Eggyolkio]

THANK YOU, THANK YOU, THANK YOU!!! I think I tried every other method but this one. Finally something easy. I would pay you if I wasn't broke and looking for a job right now, but I'll remember you when I get one!

[wayneedmondson]

Great quickie tip.. thanks for sharing. Thumbs up!!

[mohammadsadrzadeh]

How can I conditional format a whole workbook at once without VBA or Macro ? e.g. to color all cells in a workbook ( No a sheet at a time)n with the same cell value like Apple, Orange, ....?

[darrylmorgan]

This Shortcut Is In My Top 10 And Yes I Have Done ALT H E A By Mistake LOL..Thank You Sir :)

[SuzyDamari]

Or you could just use the 'clear' icon

[aspegel]

Darn... didn't work in Excel 2002.