Change Background Color for Entire Excel Sheet

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on February 7, 2024

This tutorial demonstrates how to change the background color of an entire sheet in Excel and Google Sheets.

back color intro

Change a Sheet’s Background Color: Context Menu

  1. In your current sheet, click the square in the upper-left corner. (The square is located between the row numbers and the column letters where the rows and columns intersect.) You could also select the entire sheet by pressing CTRL + A on your keyboard.

back color select all

  1. Then, right-click anywhere in your sheet to bring up a context menu, where you should click Format Cells…

back color format cells

  1. In the Format Cells dialog box, go to the Fill tab.

back color dialog fill

  1. Choose a new fill color, and then click OK.

back color colored sheet

  1. All cells in the entire sheet now have the new background color.

Change a Sheet’s Background Color: Ribbon

  1. Once again, select the entire sheet by using the corner button or the CTRL + A shortcut.
  2. Then, in the Ribbon, go to Home > Font and then click the arrow to the right of the Fill Color icon.
  3. Choose a color to apply to your sheet automatically, or click More Colors… to open the Format Cells dialog box if you don’t see the color you want.

back color ribbon fill

Hide Gridlines

By default, an Excel sheet shows gridlines. If you change the background color of your sheet, you effectively hide these gridlines. Alternatively, if you do not have a fill color set, you can hide your gridlines using the Ribbon.

In the Ribbon, click View > Show and then uncheck the Gridlines box to hide the gridlines in your sheet.

backcolor hide gridlines

Change Background Color for Entire Sheet in Google Sheets

  1. Click in the top-left corner of the Google sheet on the select all button.

background color gs select sheet

  1. Then, in the Menu, click the Fill drop down, and then choose a color to apply.

background color gs select color

  1. The background of every cell in the sheet changes to that color.

background color gs colored

AI Formula Generator

Try for Free

See all How-To Articles