How to Print Gridlines in Excel: Complete Guide (2026)

Quick Overview

Want to print gridlines in your Excel spreadsheets? This comprehensive guide shows you how to print gridlines in Excel 2026 for both Windows and Mac versions. You will learn multiple methods to ensure your printed spreadsheets are easy to read and professionally formatted. Whether you are creating financial reports, data tables, or project documentation, gridlines help readers track information across rows and columns, making your documents significantly more usable and professional.

Why Print Gridlines in Excel

Gridlines are the faint gray lines that separate cells in Excel worksheets. While they are visible on screen by default, they do not automatically print unless specifically configured. Understanding when and why to print gridlines helps create professional documents that communicate data clearly and prevent errors.

Benefits of Printed Gridlines

• Improved Readability: Gridlines help readers track rows and columns, especially in large datasets with dozens or hundreds of entries. Without visual separation, data can blur together, making it difficult to follow across pages
• Data Alignment: Cells remain visually separated, preventing data from appearing to run together. This is particularly important for financial data where decimal alignment matters
• Professional Appearance: Documents with gridlines look more polished and easier to reference during meetings. Printed spreadsheets without gridlines can appear unfinished
• Error Reduction: Clear cell separation reduces mistakes when manually transferring data or reading values. This is crucial when others will use your printed documents

When to Use Gridlines

Consider printing gridlines when creating financial reports or budgets, sharing data tables with colleagues, printing forms that require manual data entry, presenting spreadsheets in meetings, or creating reference documents for data analysis. However, for highly designed presentations or when cell colors are important, you might choose to use borders instead.

Method 1: Page Layout Tab (Recommended)

The Page Layout tab provides the most straightforward way to configure gridline printing. This method works consistently across all modern Excel versions and is the recommended approach for most users.

To enable gridlines, open your Excel workbook and navigate to the worksheet you want to print. Click the Page Layout tab in the Excel ribbon at the top of the window. Look for the Sheet Options group, usually located on the right side of the ribbon. Under the Gridlines section, check the box labeled Print. Press Ctrl+P to open Print Preview and verify the gridlines appear as expected before printing.

Understanding Sheet Options

The Sheet Options group contains two important settings that work independently. The View checkbox controls whether gridlines are visible on your screen while editing. The Print checkbox controls whether gridlines appear on printed output. You can have gridlines visible on screen but not print them, or hide them on screen but include them in prints, depending on your needs.

Method 2: Page Setup Dialog

For users who need additional printing options or prefer dialog-based configuration, the Page Setup dialog provides comprehensive control over all printing settings.

Access the Page Setup dialog by clicking the small arrow in the bottom-right corner of the Sheet Options group on the Page Layout tab. Alternatively, press Ctrl+P to open Print Preview, then click the Page Setup link. You can also access it through File, Print, Page Setup.

Once the dialog opens, click on the Sheet tab. Under the Print section, check the box labeled Gridlines. Click OK to apply the settings, then preview your document to confirm the gridlines appear correctly.

Additional Options in Page Setup

The Sheet tab in Page Setup offers additional useful options beyond gridlines. You can select Black and White to print in grayscale, which saves color ink. Draft quality prints faster with reduced quality, suitable for internal drafts. Row and column headings prints the letter column headers and number row headers, which is helpful for large spreadsheets. You can also choose where comments appear, either at the end of the sheet or as displayed on screen.

Method 3: Print Preview Settings

You can also configure gridlines directly from the Print Preview screen, making it easy to see changes in real-time before committing to print.

Press Ctrl+P to open Print Preview. Look for the Settings section on the left side of the screen. Click the link labeled Page Setup. In the dialog that appears, select the Sheet tab. Check the Gridlines checkbox, then click OK and review the preview to ensure everything looks correct.

Printing Specific Ranges with Gridlines

Often you only need to print a portion of your spreadsheet rather than the entire worksheet. Excel allows you to define print areas while maintaining your gridline settings.

To set a print area, select the cells you want to print by clicking and dragging to highlight them. Go to the Page Layout tab and click Print Area in the Page Setup group. Select Set Print Area from the dropdown menu. The selected range is now defined as your print area. Enable gridlines using one of the methods described earlier. When you print, only the selected range will output with gridlines included.

To clear a print area and return to printing the entire worksheet, go to Page Layout, Print Area, and select Clear Print Area.

Using Borders Instead of Gridlines

For more professional documents, consider using borders instead of default gridlines. Borders provide more control over appearance and work with colored cells, unlike gridlines which only appear on white backgrounds.

Applying Borders

Select the cells where you want borders by clicking and dragging. Go to the Home tab on the ribbon. In the Font group, click the Borders dropdown arrow. Select All Borders to outline every cell in your selection, or choose Outside Borders to outline only the perimeter of your selection.

Customizing Border Appearance

For more control over border appearance, use the Format Cells dialog. Select your cells and right-click, then choose Format Cells. Click the Border tab in the dialog. Here you can select different line styles and colors. Click in the preview area to apply borders to specific sides of cells. This allows you to create professional-looking tables with varying line weights and colors.

Borders vs Gridlines Comparison

Gridlines have limitations: they do not work with colored cells, cannot be customized in color or thickness, apply to the entire sheet rather than specific cells, and must be enabled each time you want to print them. Borders, by contrast, work with any cell color, can be customized in both color and line thickness, can be applied to specific cell ranges, and remain with the file permanently once applied.

Troubleshooting Gridline Printing Issues

Gridlines Not Showing in Print Preview

If gridlines do not appear when you preview your document, first verify that gridlines are actually enabled in Page Layout or Page Setup. Next, check if your cells have fill colors applied. Gridlines only print on cells with white backgrounds. Remove fill colors by selecting the cells, going to Home, Fill Color, and selecting No Fill. Also ensure you are not in Page Break Preview mode, as this can affect gridline display. Switch to Normal view if necessary.

Gridlines Print Too Light

Default gridlines are intentionally subtle and may appear too faint for some uses. If you need darker lines, use borders instead of gridlines. Set the border color to black or dark gray and choose a thicker border style for better visibility.

Gridlines on Some Sheets Only

Remember that gridline settings are worksheet-specific, not workbook-wide. If you have a multi-sheet workbook, you must repeat the enable steps for each worksheet where you want gridlines to print. You can select multiple sheet tabs by holding Ctrl and clicking each tab, then apply settings to all selected sheets simultaneously.

Gridlines Cut Off at Page Breaks

If gridlines appear incomplete across page breaks, try adjusting your page scaling settings. Go to Page Layout, Scale to Fit, and experiment with different scaling percentages. Changing the page orientation to Landscape can help with wide spreadsheets. You can also adjust margins through Page Layout, Margins to fit more content on each page.

Excel Online and Mobile Considerations

Excel for the Web

Excel Online has limited gridline printing options compared to the desktop version. Gridlines typically print automatically in most cases, but customization options are restricted. For best results with specific formatting needs, use the borders method described earlier, which works consistently across all Excel versions.

Excel Mobile Apps

Mobile versions for iOS and Android offer basic printing through the Share menu. However, printing options vary significantly by device and operating system. For precise control over gridlines and other formatting, always use the desktop version of Excel when possible.

Best Practices for Printed Spreadsheets

Always preview your document before printing using Ctrl+P. This catches formatting issues before you waste paper and ink. Include headers and footers for page numbers and document titles through Page Layout, Page Setup, Header/Footer. For multi-page reports, repeat header rows on every page so column labels remain visible. Use the Rows to Repeat at Top option in Page Setup.

Consider using Fit to Page options for wide spreadsheets that might otherwise print across multiple pages awkwardly. Landscape orientation often works better for data-heavy spreadsheets than portrait orientation.

Conclusion

Printing gridlines in Excel is a simple process once you know where to find the settings. Whether using the Page Layout tab, Page Setup dialog, or borders for more control, these techniques ensure your printed spreadsheets are professional and readable. For complex documents with colored cells or specific formatting requirements, borders provide greater customization and compatibility.