How to Remove Cell Shading in Excel 2013

Cell fill colors in Microsoft Excel can be a really effective way to highlight certain rows or columns that are related, or deserve additional attention. But if you move rows or columns around, then this cell shading or fill color can become problematic or incorrect.

If you find that the fill color is distracting or not useful, then you might decide to simply remove it from the spreadsheet. Our guide below will show you how to quickly remove all of the fill color from your spreadsheet with just a few short steps.

 

Remove Cell Fill Color in Excel 2013

The steps in this article will show you how to remove any fill color that is contained within the cells of your spreadsheet. If these steps do not work, then there may be additional formatting applied to the spreadsheet that is preventing you from removing the fill color. This article will show you how to remove it if someone else created the spreadsheet and applied conditional rules to it. If the spreadsheet has been password protected, then you will need to obtain the password from the spreadsheet creator in order to edit the spreadsheet. You can then follow the steps here to remove the password.

 

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Click the cell at the top-left corner of the spreadsheet, between the 1 column number and the A row letter. This will select the entire spreadsheet.

select all of the cells in the spreadsheet

 

 

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

click the home tab

 

 

Step 4: Click the arrow to the left of the Fill Color button.

click the arrow to the right of the fill color button

 

 

Step 5: Click the No Fill option. All of the fill color in the cells of your spreadsheet should now be removed.

click the no fill option

 

 

Are you printing a multi-page Excel spreadsheet? This article will show you how to print the top row of headings on every page to make it easier for the printed document to be read.

solveyourtech.com newsletter
vintage t rex t-shirt

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