When printing an Excel spreadsheet in black and white, solid color fills can become indistinguishable shades of gray. This makes data hard to read and key information difficult to highlight. Excel provides diagonal lines and patterns as cell fills that translate clearly to monochrome output. This article explains how to use these pattern fills to maintain visual distinction in printed reports.
Key Takeaways: Using Patterns for Clear Monochrome Printing
- Home > Font > Fill Color > More Colors > Patterns: Opens the dialog to apply a pattern fill and set its foreground and background colors.
- Pattern Style dropdown: Contains over a dozen patterns like diagonal stripes, grids, and dots that print clearly without color.
- Foreground and Background color selectors: Define the pattern’s line color and the cell’s base color, which can both be set to black, white, or gray.
Understanding Pattern Fills for Print Readability
Pattern fills are a formatting feature in Excel that applies a repeated design to a cell’s background. Unlike a solid color, a pattern uses two colors: one for the pattern lines or dots themselves, and another for the spaces between them. This creates high-contrast texture that remains distinct when a color printer uses only black ink or when a document is photocopied.
The key to effective use is contrast. For a white cell, a black diagonal stripe pattern is highly visible. For a cell with a dark gray fill, a white grid pattern will stand out. You control both the pattern style and its two component colors independently. This allows you to design for maximum legibility on the final printed page, regardless of the on-screen colors.
Available Pattern Styles
Excel offers a fixed set of pattern styles. The most useful for monochrome printing are the diagonal stripes (both directions), the grid patterns, and the dotted patterns. Solid fills and a few gradient-like patterns are also available but are less effective for black-and-white differentiation. You cannot create custom pattern designs.
Steps to Apply a Pattern Fill to Cells
- Select the target cells
Click and drag to select the cell or range of cells you want to format with a pattern. - Open the Format Cells dialog
Right-click the selected cells and choose Format Cells from the context menu. Alternatively, press Ctrl+1 on your keyboard. - Navigate to the Fill tab
In the Format Cells dialog box, click the Fill tab at the top. - Open the Pattern Style menu
In the lower section of the tab, click the drop-down arrow next to “Pattern Style.” A gallery of patterns will appear. - Choose a pattern
Select a pattern from the gallery, such as the thin diagonal stripes or the small grid. - Set the Pattern Color
Click the drop-down arrow next to “Pattern Color” directly below the style menu. Choose a dark color like black or a dark gray for the pattern lines. - Set the Background Color
In the upper section of the tab, under “Background Color,” click a color square. For high contrast with a black pattern, choose white or a very light gray. Click OK to apply.
Applying a Pattern Using the Ribbon
A quicker method exists for applying a basic pattern without opening the full dialog.
- Select your cells
Highlight the cells you wish to format. - Open the Fill menu
On the Home tab of the ribbon, in the Font group, click the small arrow next to the Fill Color paint bucket icon. - Select More Colors
At the bottom of the color menu, click “More Colors.” - Switch to the Patterns tab
In the Colors dialog box that appears, click the “Patterns” tab. You will see the same style and color selectors. Choose your pattern and colors, then click OK.
Common Mistakes and Limitations to Avoid
Pattern and Background Colors Are Too Similar
If you set the pattern color to a medium gray and the background color to a slightly lighter gray, the pattern will be nearly invisible when printed. Always test print a sample section. Ensure there is significant tonal difference between the two colors. Using black for the pattern and white for the background is the safest, highest-contrast combination.
Forgetting to Check Print Preview
A pattern may look clear on your screen but can become muddy or indistinct when printed at a lower resolution. Always use File > Print to view the Print Preview. This shows you exactly how the patterns will appear on paper. Adjust the pattern color to a darker shade if the preview looks faint.
Patterns Do Not Copy with Paste Special > Formats
When you copy a cell with a pattern fill and use Paste Special to paste only the formats, the pattern fill is copied correctly. However, if you use the standard Paste command or the Format Painter tool, the pattern may not transfer as expected depending on the destination cell’s existing format. For reliable copying, use the Format Painter tool directly or use Paste Special > Formats.
Pattern Fills vs. Cell Borders for Monochrome Printing
| Item | Pattern Fills | Cell Borders |
|---|---|---|
| Primary Use | Filling the entire cell interior with texture | Defining the edges or outlines of cells |
| Print Clarity | Excellent for shading large areas or creating data bands | Excellent for creating grids and separating data points |
| Customization | Fixed style library, two-color control | Full control over line style, thickness, and color for each side |
| Best For | Categorizing rows, highlighting columns, creating non-color legends | Creating tables, framing headers, visually grouping data |
| Overuse Effect | Can make sheet look busy and hard to read | Can create a cluttered “grid prison” effect |
You can now apply diagonal stripes, grids, and dot patterns to Excel cells to ensure your printed reports are readable without color. Use the Format Cells dialog for the most control over both the pattern style and its colors. For your next project, try combining a light gray solid fill with a dark gray diagonal stripe to create professional-looking shaded rows. Remember that the F4 key repeats your last formatting action, allowing you to quickly apply a tested pattern to multiple cell ranges.