How to grey out unused cells in Google Sheets
By
SpreadCheaters
The following dataset represents the product code and the names of the products. Some cells are used, i.e.; from C4 to D11, all the other cells are unused, which means that no data is being plotted here, so, in this tutorial, we will learn how to gray out those unused cells. Follow the given steps to achieve this.
In Google Sheets, “graying out unused cells” refers to a visual formatting technique where cells that are not being actively used are shaded or displayed with a gray color. This can be helpful in large spreadsheets to visually distinguish between the cells containing relevant data and the unused cells. By graying out the unused cells in the data we can bring attention to the relevant data, which can improve readability.
In Google Sheets, “graying out unused cells” refers to a visual formatting technique where cells that are not being actively used are shaded or displayed with a gray color. This can be helpful in large spreadsheets to visually distinguish between the cells containing relevant data and the unused cells. By graying out the unused cells in the data we can bring attention to the relevant data, which can improve readability.
Step 1 – Select the range of the cells
– If you want to gray out the unused cell, you need to select the whole sheet.
– This can be done by clicking on the rectangle on the top left corner of the sheet.
Step 2 – Locate the format tab
– Locate the format tab, and click on it.
– A drop-down menu will appear, choose “conditional formatting” from that.
Step 3 – Insert the formula
– When you click on “conditional formatting” a sidebox will open.
– Under format rules, in the “format cells if” category, choose the “custom formula is” option.
– Insert the formula “=ISBLANK(A1)”.
The alternative of step 3
– When you click on “conditional formatting” a sidebox will open.
– Under format rules, in the “format cells if” the category, choose the option “is empty”
Step 4 – Choose the color
– From the “formatting styles” category, from the fill color option, choose the color gray.
– Click on “Done”.
Step 5 – Choose the color for the borders
– In the quick access toolbar, choose the option, borders.
– Now click on the color option and choose the grey color.
– Click on the all borders option.
– Now you can see that all the unused cells are grey out.
