How to Remove Cell Formatting in Excel - Excel Trick to Clear all Formatting

We can Clear Cell Formatting in Excel by selecting data and then on Home Tab go to Editing Section and select Clear Formats. Keyboard Shortcut for removing all formatting of cells in excel is Alt E A F.

[@rebeccahmar388]

I've been looking for this everywhere! 😅 Thank you!

[@ExcelDestination]

Welcome!

[@VJBang907]

Yes! Simply sorted the issue driving me mad! Thanks

[@ExcelDestination]

Welcome

[@Daanyaal007]

Will this work if using extracted data?

[@aaquib...5390]

Nice one Thanku....

[@ganeshadhikary4728]

Thank you so much Sir.❤❤❤

[@ExcelDestination]

Welcome

[@abdiwahabahmedomar2399]

Thank you

[@khalidaaghayeva841]

Thank you dear

[@bonneyfissbuyunganakkawink5938]

HI how to clear the words and keep the colours?? please help me thank you in advance

[@LucaVincent]

Thank you sir

[@ExcelDestination]

Welcome

[@ashwanthashwanth2400]

Worked great

[@ExcelDestination]

Thanks

[@idellasheart]

thank you!

[@theresajohnson8871]

Thank you.

[@ExcelDestination]

Welcome

[@alejandroastudillo3208]

Legend

[@abhinavtripathi9678]

Thanks

[@ExcelDestination]

Welcome

[@19s94]

Te amo

[@sammymutt460]

Thanks