How to Remove All Row Shading in Excel for Office 365

It’s common for someone creating a spreadsheet in Microsoft Excel to want to to draw attention to specific bits of data. One way that this is often accomplished is by highlighting a cell, column, or row with a different color. This catches the reader’s eye, and usually indicates that something in that row requires attention.

But if you are working on a spreadsheet that has some row shading, you may be adding data or deleting data, which can lead to an adjustment in both the location and importance of data. If this results in the row shading no longer being relevant, then you might need to remove it. Our guide below will show you how to quickly remove all of the row shading from an entire spreadsheet in Microsoft Excel.

How to Get Rid of All of the Fill Color in Excel

The steps in this article were performed in Microsoft Excel for Office 365, but will work in many older versions of Excel as well. Once you have completed these steps you will have a spreadsheet with no fill color, or shading, at all.

Step 1: Open your spreadsheet in Excel.

Step 2: Click on the gray cell above the row 1 heading, and to the left of the column A heading. This is going to select all of the cells in the spreadsheet.

select all cells in excel

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 arrow to the right of the Fill Color button, then choose the No Fill option to remove all of the cell shading.

how to remove row shading in excel

Are you printing your spreadsheet, but finding that the second page and on are difficult to read because you don’t know which data belongs to which column? Find out how to repeat the top row on every page and make it easier to identify your data.