Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Changing Excel's Background Color.

Changing Excel's Background Color

by Allen Wyatt
(last updated November 1, 2014)

16

The standard background color in Excel is white. You may, at some time, want to change the background color to something else, such as a light grey. Unfortunately, there is no way to change the background color; it is not a configurable option in Excel. There are a few things you can try as workarounds, however.

One approach involves selecting all the cells in the worksheet and applying a fill color to the cells. If you don't want the color to print, then you simply need to select all the cells and remove the fill color. This could be automated by using a macro to do the color removal, printing, and re-application.

There are drawbacks to such an approach, however. First, the colors used to fill the cells could interfere with the successful application of conditional formatting, if the conditional formatting involves the use of fill colors. (Conditional formatting applied to font specifications shouldn't be a problem.)

Another option is to create, in your favorite graphics program, a small rectangle that matches the color you want used for your background. Save the small rectangle as a graphics file, using the JPG file format. Then, within Excel, follow these steps:

  1. Display the Page Layout tab of the ribbon.
  2. Click the Background tool, in the Page Setup group. Excel 2007 and Excel 2010 display the Sheet Background dialog box. In Excel 2013 you see the Insert Pictures screen in which you should click the Browse link at the right of the From a File option. You'll then see the Sheet Background dialog box. (See Figure 1.)
  3. Figure 1. The Sheet Background dialog box.

  4. Use the controls in the dialog box to locate and select the graphic image you created (the small rectangle of color).
  5. Click the Open button.

The graphic image is placed in the background and repeated over and over again so that it fills the entire background. The benefit to this approach is that it doesn't affect any conditional formatting and the background image won't print.

Speaking of conditional formatting, if you aren't using conditional formatting for any purpose in a worksheet, you could use it to create your background. In a blank area of your workbook, define a cell that contains the value True. Then select your worksheet that you want to have the background color and use a conditional format to define that color. The format can look at the cell you defined, and if it is True, then the color is applied. If the cell is not True, then the color is not applied. This allows you to turn the background color on or off (for printing) by changing the value of a single cell.

You could also define styles for use in your worksheet. Define a style that has the desired background color, and another that does not. You can then apply the colored style when editing and the non-colored style when preparing to print.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6121) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Changing Excel's Background Color.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Copying Form Field Contents

Are you developing a form with Word? In some instances it is advantageous to copy whatever is entered in a form field to ...

Discover More

Watermarks in Excel

Excel is great at printing numbers on a piece of paper, but terrible at printing watermarks. This is apparently by design, as ...

Discover More

Turning Off Track Changes without Unsharing

The Track Changes tool in Excel can be helpful, but it can also be aggravating because it doesn't allow you to use it on a ...

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

More ExcelTips (ribbon)

Setting Page Margins

When getting ready to print your worksheet, you may want to take a moment to check what margins Excel will use on the ...

Discover More

Copying Formats to a New Worksheet

Do you want to copy formats from one worksheet to another? You can do so easily by using the Format Painter. It even works on ...

Discover More

Random Width and Height Changes

Have you ever been using a workbook, only to open it one day and find that Excel has changed the height of your rows or the ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 8Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 0 + 7?

2017-03-20 16:33:44

Mander

I am using Excel 2007 to do a spreadsheet, I want to make the sheet colored every other line can I lock that color so it cannot be changed?


2017-03-04 12:24:21

Willy Vanhaelen

The advantage of the 'Backgroound' file approach is that the gridlines remain.
With the 'Fill Color' and 'conditional formatting' approaches they disappear.


2017-03-03 02:32:28

Anonymous

JPG should not be used for a flat color, PNG is superior.


2017-01-24 00:26:25

TERESA

I did it....Go to Control PanelAppearance and PersonalizationPersonalization....click on Themed Backgrounds.

I have Windows 10, Excel 20116

This will change your sheet background from black background/white print to white background/black print.


2016-10-14 01:11:32

Eileen

I made changes to the color on my computer. I apparently did it wrong, I sort of changed a lot of things, especially on Excel. My spreadsheet is in all black. I want to change it back to white (the color before the change.) but I don't remember what is changed.


2016-09-28 00:11:53

walter

John

I had the same problem when I saved a file as an Excel 97-2003 Worksheet.
File size was 3,142 KB

Saving the same file as an Excel Worksheet, the file size dropped to 55 KB, a huge difference.

Maybe this will fix your problem.


2016-04-09 05:49:28

john

I tried the graphics file approach and the file size became so huge it was unmanageable.


2016-03-08 17:34:17

Dan

This is awesome. Thank you!


2016-02-20 11:38:12

Bonnie Azzelino

I am not sure - I read the above tutorial but I don't think this is the answer to my issue. Would you please read my post below, and comment? Is this something to do with a page 'resolution'? Your comments are appreciated.
["PLEASE HELP ME FIX A BLACK SCREEN - I have accidentally changed my laptop from a white screen to a black screen. Pages affected are the Start Screen, the Menu Screen and the Apps Screen. Once I am on the internet (Facebook, Gmail, etc) all is fine. It is extremely difficult to work in XCel when the screen is black with white letters. PLEASE - does anyone know how to fix this? (I've searched the help sections but cannot find an answer because I really don't know the question. The change happened as I was trying to unlock a frozen Xcel screen - poof. all went black. Since I don't know what I did, I don't know how to fix.) Any help is appreciated!"]


2015-12-12 03:00:44

SAIBABA

sir i am saibaba i am page break this time page back side came page1, the back Sade i am given other name how to tall me sir


2014-12-03 11:40:00

Paul

Start Menu > Accessories > Ease of Access > Magnifier

Then press ctrl+alt+i which activates the built in Windows colour inverter. This inversion applies to the entire computer but it is easy to switch on and off when in Word / Excel etc and when you're not.


2014-11-06 17:03:25

Ken

I used Windows Themes to change the background color from white for all my programs. Light gray, light blue etc. are much easier on the eyes.


2014-11-04 11:34:38

Glenn Case

Good tip, Peter!


2014-11-03 14:44:42

Peter Ham

The white background hurts my eyes after a few hrs, so I've changed the background color on ALL Windows by right clicking on the desktop, then:
PersonalizationWindow Color and AppearanceAdvanced Appearance Settings

Then set the color of the active window to something less contrasting than bright white.


2014-11-01 12:16:16

Clay

Wow - great tip. What does it do to the file size, though? Does it increase it by only one jpeg? That wouldn't be so bad. I'm assuming it doesn't repeat the image file over and over?

Thanks for the tip!


2014-11-01 12:13:48

Willy Vanhaelen

Interesting typ.

Up to now I used the fill Color approach but I disliked that the grid lines then disappear.

Using the Sheet Background in Page Layout option of this typ, now the gridlines remain :-)


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.