How to Remove Shading from Cells in Google Sheets

The steps in this article are going to show you how to select a group of cells in Google Sheets and remove any shading that’s been applied to them.

  1. Sign into your Google Drive and open the file with shading.
  2. Use your mouse to select the cells from which to clear the shading.
  3. Click the Fill color button in the toolbar.
  4. Select the Reset option.

Applying fill color to cells in Google Sheets is a good way to highlight important information.

But as data changes, or is moved to different locations, the highlighted cells may no longer be correct.

Luckily you can remove shading from cells in Google Sheets in a manner similar to how that shading was first applied.

Our guide below is going to show you how to remove highlighting in Google Sheets by selecting those cells and choosing an option on the Fill color menu.

How to Clear Shading from Cells in Google Sheets

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Firefox or Edge.

Step 1: Sign into your Google Drive at https://drive.google.com and open the Sheets file containing the shading to remove.

Step 2: Select the cells with the shading you want to remove. Note that you can click the row numbers at the left or the column letters at the top to select entire rows or columns. You can also select multiple rows or columns by clicking the first one, then holding down the Shift key and clicking the last one.

select the cells with shading to remove

Step 3: Select the Fill color button in the toolbar at the top of the sheet.

click the Fill color button

Step 4: Click the Reset button.

how to remove shading from cells in Google Sheets

Find out where the gridlines went on your Google Sheets file if they aren’t visible or aren’t being printed.