Removing Cell Formatting in Excel 2013

Large Excel files can be difficult to read, especially when they contain a lot of data, only some of which might be relevant to a particular situation. A simple way to make important data stand out is to change the way it looks. Whether this involves changing the color of a cell, adding a border, or modifying the text effects, there are a number of different options. But when you need to use formatted cells in a situation where you don’t want them to be formatted, then manually changing each adjustment can be time-consuming and frustrating. Luckily Excel 2013 has a simple way to clear cell formatting from a group of selected cells, and you can learn how to use it by following the tutorial below.

Have you been thinking about getting a tablet or a laptop? This affordable Asus machine is both, and you can even use it to run Microsoft Office.


Clearing Excel 2013 Cell Formatting

This is especially useful if you receive an Excel file from a client or colleague that has formatting that is preventing you from modifying the document in the way that you need. Erasing cell formatting will allow you to keep the content of the cells (including formulas) while stripping those cells of the unwanted appearance modifications.


Step 1: Open the spreadsheet in Excel 2013.


Step 2: Use your mouse to highlight the cells containing the formatting that you want to remove.

select the cells you want to modify



Step 3: Click the Home tab at the top of the window.

click the home tab at the top of the window



Step 4: Click the Clear button in the Editing section of the ribbon (it’s at the far-right side), then click the Clear Formats option.

how to remove cell formatting in excel 2013



If you’re looking for an affordable, fast way to print your work documents, then this wireless Brother laser printer is a great choice.

Find out how to adjust the print settings in Excel 2013 so that multiple-page Excel files fit to the page more easily. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.