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?
Best Answer
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)