how to print background in excel

How to Print Background in Excel: Easy Step-by-Step Guide

By Amanda Taylor
AD

Printing the background colors and gridlines in Microsoft Excel often trips up users, as the default settings prioritize a clean, white-page output. By default, Excel suppresses these visual elements to save ink and create a minimalist professional look. However, if you have spent time formatting your cells with brand colors or subtle shading to organize data, sending that sheet to the printer without them can make your work look incomplete and hard to read.

To successfully print background in Excel, you must move beyond the standard Page Layout tab and adjust specific settings within the Page Setup dialog box. This is where the logic of the software becomes clear: the printer needs explicit instructions to ignore the "Do not print" flag that Excel applies to backgrounds by default. The solution involves a combination of checking the correct boxes in the Sheet tab and ensuring your gridlines are configured to print, which effectively recreates the visual structure of your screen on paper.

Preparing Your Worksheet for Print

Before diving into the technical settings, it is essential to prepare your worksheet correctly. If your goal is to have colored cells appear on the page, you must ensure that the gridlines themselves are what create the appearance of your background. Many users attempt to print background colors without understanding that Excel treats gridlines as a separate layer. If the gridlines are turned off on the screen, they usually will not print, regardless of how vibrant your cell shading is.

AD
How to enlarge an image to print on multiple pages using Microsoft Excel Tutorial
How to enlarge an image to print on multiple pages using Microsoft Excel Tutorial
Print Sheets in Excel
Print Sheets in Excel
How to Print in Excel - Step-by-Step Guide?
How to Print in Excel - Step-by-Step Guide?

To verify your gridline settings, navigate to the View tab on the Ribbon. Look for the Gridlines checkbox in the Show group. If it is unchecked, your cells are floating on a white canvas, and even if you apply a color to a cell, it will essentially be a hidden color on a white page when you print. Checking this box ensures that the structure of your data is visible on screen and, more importantly, provides the framework for printing background in Excel.

Accessing the Page Setup Menu

Method 1: The Quick Access Toolbar

The fastest way to access the necessary printing settings is through the Page Setup launcher. This small arrow icon is usually located at the bottom right corner of the Page Setup group on the Page Layout tab. Clicking this icon opens the comprehensive Page Setup dialog box, which contains all the advanced controls for managing how your document interacts with the physical page.

How to Set the Print Area in Excel (with pictures)
How to Set the Print Area in Excel (with pictures)
Excel Formatting Tips - Tip 20 - Print-Setup in Excel
Excel Formatting Tips - Tip 20 - Print-Setup in Excel
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step

Method 2: The Keyboard Shortcut

For efficiency, power users prefer the keyboard shortcut to open this menu. By pressing Ctrl + P, you bring up the print panel. At the bottom of this panel, you will find a link that says "Page Setup." Clicking this link bypasses the basic print screen and takes you directly to the precise menu where the background settings reside.

Adjusting the Sheet Tab Settings

Once the Page Setup dialog box is open, you must navigate to the Sheet tab. This is the control center for what actually gets rendered on the page. Here, you will find a section labeled Print. Within this section, there are two critical options you need to manipulate to print background in Excel.

AD

First, locate the checkboxes labeled Gridlines and Background. To achieve the desired result, you generally need to check the Gridlines box. However, if you are looking to print the specific color fill of a cell rather than the lines themselves, you must check the Background box. In most modern versions of Excel, checking "Print" under Gridlines while ensuring the color fill is applied is the standard method for displaying your formatting.

How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
How To Insert Background Image In Excel
How To Insert Background Image In Excel
Como imprimir lineas de fondo hojas de calculo Excel hacer visible cuadricula
Como imprimir lineas de fondo hojas de calculo Excel hacer visible cuadricula
How to repeat row headers on each page in Excel when printing
How to repeat row headers on each page in Excel when printing
How to Adjust Page Size for Printing in Excel (6 Quick Tricks) - ExcelDemy
How to Adjust Page Size for Printing in Excel (6 Quick Tricks) - ExcelDemy

Troubleshooting Common Issues

Even after checking the correct boxes, you might find that your background is still not printing. If this happens, the issue usually lies with the printer driver settings. Many modern printers have an economy mode or a "Draft" quality setting that automatically suppresses colors and background graphics to save ink. To fix this, you need to access your printer preferences.

Before clicking print, open the Printer Properties window. Look for a Quality or Advanced tab and change the Mode to "Normal" or "Best Quality." Additionally, ensure that the "Print Background Colors and Images" option is enabled within the Excel print settings themselves. This specific override tells the printer to ignore its own economy settings and respect the formatting of the Excel file.

AD

Final Verification

Before committing to a full print run, always use the Print Preview function. This feature allows you to see exactly how the data will appear on the page. Look at the preview pane to confirm that the gridlines are displaying correctly and that the color fills are visible. If the preview looks correct, you can proceed with confidence, knowing that your printed output will match the carefully formatted data on your screen, ensuring clarity and professionalism for your audience.

Changing Excel's Background Color (Microsoft Excel)
Changing Excel's Background Color (Microsoft Excel)
Excel Print Options, Tips and Tricks Tutorial
Excel Print Options, Tips and Tricks Tutorial
How to remove an image background in Excel. 🤯
How to remove an image background in Excel. 🤯
the poster shows how to unhide columns in excel
the poster shows how to unhide columns in excel
Format Painter in Excel (Quickly Copy Any Formatting)
Format Painter in Excel (Quickly Copy Any Formatting)
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
how to print a large excel spreadsheet on one page
how to print a large excel spreadsheet on one page
a hand drawn diagram on top of a piece of paper with words written in it
a hand drawn diagram on top of a piece of paper with words written in it
Make Graph Paper in Excel (+ video tutorial!)
Make Graph Paper in Excel (+ video tutorial!)
Conditionally Format Chart's Background in Excel - How To - PakAccountants.com
Conditionally Format Chart's Background in Excel - How To - PakAccountants.com
the excel interface explaining how to use excel
the excel interface explaining how to use excel
Basic Formatting in Google Sheets
Basic Formatting in Google Sheets
9 Tips to Get Perfect Excel Printouts
9 Tips to Get Perfect Excel Printouts
How to Make Graph Paper in Excel - Tutorial
How to Make Graph Paper in Excel - Tutorial
AD