Answer

To print gridlines in Excel, navigate to the Page Layout tab, locate the Sheet Options group, and check the Print box under Gridlines. This makes the cell borders visible on your printed document.

Steps to Enable Gridline Printing

1. Open your Excel workbook and select the worksheet you want to print.
2. Click the Page Layout tab in the ribbon.
3. Find the Sheet Options group on the right side of the ribbon.
4. Under Gridlines, check the box labeled Print.
5. Click File, then Print to preview and print your worksheet with gridlines visible.

The gridlines will now appear on your printed pages, showing the cell boundaries that normally display only on screen.

Alternative Method Using Page Setup Dialog

You can enable gridline printing through the Page Setup dialog box for more printing options.

1. Click the Page Layout tab.
2. Click the small arrow icon in the bottom-right corner of the Page Setup group to open the Page Setup dialog.
3. Select the Sheet tab within the dialog box.
4. Check the box next to Gridlines under the Print section.
5. Click OK to apply the setting.
6. Proceed to print your worksheet.

This method provides access to additional print settings in one location.

Keyboard Shortcut to Access Page Setup (Windows)

Press Alt + P, then S, then P to open the Page Setup dialog quickly on Windows. This keyboard sequence activates the Page Layout tab, then opens the Page Setup dialog, where you can enable gridline printing.

For Mac: Press Fn + Option + F6 to cycle through ribbon tabs, then use arrow keys to navigate to Page Layout and access Page Setup through Command + P for print settings.

Verifying Gridlines in Print Preview

Check Print Preview before printing to confirm gridlines appear correctly.

1. Click File, then Print.
2. Examine the preview pane on the right side.
3. Verify that gridlines display around cells.
4. Adjust settings through Page Setup if gridlines don't appear as expected.

The preview shows exactly how your document will print, preventing wasted paper from incorrect settings.

Difference Between View and Print Gridlines

Excel separates gridline display settings into two categories: View and Print. The View checkbox under Sheet Options controls whether gridlines appear on your screen while working. The Print checkbox controls whether gridlines appear on printed documents. You can enable one without affecting the other, allowing screen display without printed gridlines or vice versa.

Printing Gridlines for Specific Cell Ranges

You cannot print gridlines for only a portion of a worksheet using the built-in gridline feature. The gridline print setting applies to the entire worksheet. Use borders instead for selective cell edge printing.

1. Select the specific range of cells you want to have visible borders.
2. Click the Home tab.
3. Click the Borders dropdown in the Font group.
4. Select All Borders to apply borders to every cell in your selection.
5. Print your worksheet normally.

Borders print by default and provide precise control over which cells display edge lines.

Why Gridlines May Not Print

Several factors prevent gridlines from printing even when enabled.

Theme or background colors: Cell fill colors or worksheet background colors override gridline visibility. Remove fill colors from cells by selecting the range, clicking the Fill Color dropdown in the Home tab, and choosing No Fill.

Print quality settings: Draft quality printing disables gridlines in some Excel versions. Change print quality to standard or high through the Page Setup dialog under the Page tab.

Printer driver issues: Outdated or incompatible printer drivers may not render gridlines correctly. Update your printer driver through the manufacturer's website or your operating system's device manager.

Margin settings: Extremely wide margins can push content off the page, making gridlines invisible. Adjust margins through Page Setup under the Margins tab.

Printing Gridlines in Multiple Worksheets

Apply gridline print settings to multiple worksheets simultaneously by grouping them.

1. Hold Ctrl (Windows) or Command (Mac) and click each worksheet tab you want to include.
2. The word [Group] appears in the title bar when worksheets are grouped.
3. Navigate to the Page Layout tab and enable gridline printing as described earlier.
4. Right-click any grouped worksheet tab and select Ungroup Sheets.

The gridline setting applies to all worksheets that were grouped during the process.

Default Gridline Color

Excel gridlines print in black regardless of their screen display color. The default gridline color on screen is light gray (RGB: 192, 192, 192), but this converts to black for printing. Change the screen gridline color through File > Options > Advanced > Display options for this worksheet > Gridline color, but this doesn't affect print output.

Printing Without Gridlines

Leave the Print checkbox under Gridlines unchecked to print worksheets without gridlines. This creates a cleaner appearance for professional documents, reports, or presentations where cell boundaries distract from content. Most Excel worksheets print without gridlines by default since the Print option remains unchecked unless you enable it.

Gridlines vs. Borders in Printing

Gridlines and borders serve different purposes in Excel printing. Gridlines are light gray lines that separate cells and require manual activation for printing. Borders are customizable lines you apply to specific cells or ranges that always print by default. Borders offer color options, thickness variations, and line styles (solid, dashed, dotted), while printed gridlines appear only as thin black lines. Use gridlines for general reference and borders for emphasis or table structure.

Saving Gridline Print Settings

Excel saves the gridline print setting within each individual worksheet when you save the workbook. The setting persists between sessions, so you don't need to re-enable gridline printing each time you open the file. Each worksheet maintains its own gridline print configuration, meaning one worksheet can print with gridlines while another in the same workbook prints without them.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report