How we can add background color in EXCEL for printing?

microsoft-excel printing colors

6,338

What is the print area? What do you see when you switch to View > Page break preview? Are the page breaks where you expect them to be? If not, change the print area (in Normal view, select the cells you want to print and click Page Layout > Print Area > Set Print Area, or in Page break preview drag the blue page borders)

6,338

user2991243

Updated on September 18, 2022

Comments

user2991243 almost 2 years

How we can add background color in EXCEL for printing? I create a small image with gray color and add it to PAGE LAYOUT-Background Image. When I see the main window of EXCEL everything is fine and all cells are gray but in print page only used cells are gray and other remaining cells are white. How can I set all page background color to a specific color for printing?
- Prasanna almost 9 years
  
  As per Microsoft support site: support.microsoft.com/en-us/kb/213977, You cannot print a background graphic for a Excel worksheet
- Prasanna almost 9 years
  
  You are right @teylyn, Images from imgur do not load in my office PC. Just checked the question from the mobile app and got to see the image. Thanks
- Prasanna almost 9 years
  
  Your approach the problem is incorrect. If you add an image to the Background under Page layout - you will never see it in print. Use fill cells to get the desired colour
- Prasanna almost 9 years
  
  There is a work-around if you want to print with background extendoffice.com/documents/excel/…
- whiskeychief almost 3 years
  
  Another workaround is covered here: put an image in the header.
Prasanna almost 9 years

I guess that the OP is on a wrong path to do fill cells if he is going to use background image for that