Loading
ExcelRibbon.Tips.Net ExcelTips (Ribbon Interface)

Changing Excel's Background Color

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.

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.

Related Tips:

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!

 

Comments for this tip:

Ken    06 Nov 2014, 17:03
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.
Glenn Case    04 Nov 2014, 11:34
Good tip, Peter!
Peter Ham    03 Nov 2014, 14:44
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:
Personalization\Window Color and Appearance\Advanced Appearance Settings

Then set the color of the active window to something less contrasting than bright white.
Clay    01 Nov 2014, 12:16
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!
Willy Vanhaelen    01 Nov 2014, 12:13
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 :-)

Leave your own comment:

*Name:
Email:
  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*Text:
*What is 4+5 (To prevent automated submissions and spam.)
 
          Commenting Terms
 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2013)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2013)

Our Products

Premium Newsletters

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2014 Sharon Parq Associates, Inc.