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

so easy but I NEVER knew this! Thanks!

thank you for saving hours of work

Thank you bro.

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!

thanks

Great help thank you!!

You suck

Or you could just use the 'clear' icon

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,....?

You saved my life

loved this method

thanks

Thank you

Only useful if you are using windows.

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

It's very old shortcut

Cool

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

It's very usefully tips