How to Print Background in Excel: Simple Settings for Visible Designs

I spent years printing Excel sheets with missing backgrounds until I found this setting. It’s hidden in plain sight, and most users overlook it completely.

The solution lives in Page Setup, but only works if you’re using the right version. Older Excel builds ignore background colors entirely, no matter what you change. Newer ones need one checkbox enabled before printing.

You’ll get exact on-page previews of how your design will look, with colors and images intact. No more guessing if that logo or shaded cell will appear on paper.

Works for Windows and Mac, though the menu paths differ slightly. Here’s the foolproof way to make it happen.

What Youll Need

Instructions

Here’s the process I use to get backgrounds printing in Excel without any hassle.

Start by opening your Excel workbook and navigating to the Page Layout tab on the ribbon. This is where all the print-related options live. I always double-check that I’m on the correct sheet before making any changes.

Look for the Page Setup group, then click the small arrow in the bottom-right corner to open the full Page Setup dialog box. This gives you access to all the advanced print settings that aren’t visible on the main ribbon.

In the Page Setup window, you’ll see several tabs at the top. Click on the Sheet tab—this is where the background printing option hides. It’s not immediately obvious, which is why most people miss it.

Here’s the thing—Excel doesn’t print backgrounds by default because they can consume a lot of ink. But if you need that watermark or colored cell shading to appear, this is the step that matters.

Under the Print section of the Sheet tab, you’ll find a checkbox labeled Print Background colors and images. Check this box to enable background printing. It’s that simple.

Don’t skip this (I learned the hard way)—if you don’t see this option, you might be using an older version of Excel. In that case, you’ll need to update your software first.

Click OK to close the Page Setup dialog, then go to File > Print to preview your document. The background colors and images should now appear in the print preview. If they don’t, double-check that you’ve enabled the correct option.

Real talk: Sometimes the preview doesn’t update immediately. Close and reopen the print preview if you don’t see the changes right away. Then send it to your printer and confirm the backgrounds appear on the physical page.

Tips and Common Mistakes

These simple adjustments will help you avoid frustration and get perfect results every time.

Step 2 Clarity: The Sheet tab in Page Setup is easy to overlook because it’s tucked between Page and Header/Footer. I’ve watched many users skip right past it, assuming all print options would be under the Page tab. Take your time here—this is where the magic happens.

Software Version Check: If you don’t see the “Print Background colors and images” checkbox in Step 3, your Excel version might be outdated. Older versions (pre-2010) often lack this feature entirely. Updating is the only reliable fix—no workarounds will enable this option if it’s not there.

Preview Refresh: In Step 4, if your backgrounds don’t appear in the print preview, don’t assume the setting didn’t stick. Close the preview window completely, then reopen it. Excel sometimes needs a full reset to reflect changes, especially with graphics-heavy files.

Ink Consideration: Excel blocks background printing by default to save ink, which is thoughtful but inconvenient. If you’re printing a single sheet with light shading, the impact is minimal. For large jobs with dark backgrounds, though, budget for extra ink cartridges.

Frequently Asked Questions

Printing backgrounds in Excel can elevate your documents, and now you know how! Enable the “Print Background Colors and Images” option in Page Layout settings, and your designs will shine on paper. 💡 Try it out with your next report or presentation—your audience will notice the difference!