Fill color is a helpful tool for highlighting data in a spreadsheet. It has long been used for a number of purposes in Microsoft Excel, and the Google Sheets application continues that tradition by offering its own tool that you can use for fill color. Whether there’s an entire row, a single cell, or a large merged cell, you can apply a fill color to it.
But if you have a spreadsheet that currently contains unwanted fill color, you might be looking for a way to remove it. Our guide below will help you to accomplish this and revert your existing row with fill color to a row that does not have any fill color.
How to Eliminate the Shading from a Row in Google Sheets
The steps in this article were performed in the Web-browser version of Google Sheets. This guide assumes that you currently have a Google Sheets spreadsheet with a row containing fill color that you would like to remove. Note that you can use a similar method if you would like to change the current fill color to something different.
Step 1: Go to your Google Drive at https://drive.google.com/drive/my-drive and double-click the spreadsheet containing the fill color that you want to remove.
Step 2: Click the row number of the row with the fill color to remove.
Step 3: Click the Fill color button, then click the Reset option.
Is there data in your spreadsheet that you would like to sort alphabetically? This article can show you what you need to do in Google Sheets to sort your data.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.