1
Thanks

A few words of thanks would be greatly appreciated.

How To Remove All Cell Formatting on Excel


Microsoft Excel is well known for its ability to store, organize, and calculate data in a spreadsheet. As part of this offering, the software allows you to format cells with various formulae and settings to help automate tasks and keep your information uniform.


While hugely helpful, removing or changing cell formatting can be a bit tricky. This article will teach you a foolproof way to remove cell formatting from an Excel document.

How To Clear Formatting from an Excel Sheet

Press [CTRL] + A to select all of the cells.

Next, click the Home tab > Editing section > Clear Formats:


All of the data in your cells will now be in plain text.

Image: © Dzmitry Kliapitski - Shutterstock.com
1
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team

Published by . Latest update on by Olivia Long.

This document, titled "How To Remove All Cell Formatting on Excel," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
1 vote - 5.0 /5

1 Comment

Kept trying to change the fill and change the color font and nothing worked. I had gone too far to delete columns and start anew. You saved me a ton or time. Thank you.