How to Print Background in Excel: Easy Step-by-Step Guide
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.
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.
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.
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.
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.
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.