How to print gridlines in Excel

The most straightforward way to print Excel with lines is through the Page Layout settings. This method ensures all cell gridlines appear on your printed document.

1. Open your Excel workbook and select the worksheet you want to print
2. Click on the Page Layout tab in the Excel ribbon
3. Look for the Sheet Options group (usually located in the middle of the ribbon)
4. Under the Gridlines section, you'll see two checkboxes: View and Print
5. Check the Print checkbox to enable gridline printing
6. Go to File > Print or press Ctrl+P to access Print Preview and verify the gridlines appear

Sometimes you may want to print only specific lines rather than all gridlines. In this case, adding cell borders gives you more control over which lines appear in your printed document.

1. Select the range of cells where you want borders to appear
2. Right-click and choose Format Cells from the context menu
3. Click on the Border tab
4. Choose your preferred line style and color
5. Select which borders to apply: outline, inside, top, bottom, left, or right
6. Click OK to apply the borders

You can also use the border tools in the Home tab by selecting your cells and clicking the border dropdown arrow next to the border icon in the Font group.

Understanding the difference between gridlines and borders helps you choose the right method for printing Excel spreadsheets with lines: Gridlines:

• Light gray lines that separate all cells
• Appear uniformly across the entire worksheet
• Cannot be customized for color or thickness
• Don't print by default
• Applied to the entire sheet at once

Borders:

• Can be applied to specific cells or ranges
• Customizable in color, style, and thickness
• Always print when applied
• Can be applied selectively (top, bottom, sides, etc.)
• Override gridlines where applied

Choose gridlines when you want consistent lines throughout your spreadsheet, and borders when you need specific formatting or want to highlight particular sections.

Excel doesn't print gridlines by default because many users prefer clean printouts without the visual clutter of lines around every cell. This default setting works well for:

• Professional reports and presentations
• Documents where spacing and formatting provide sufficient visual separation
• Charts and graphics that don't need cell boundaries
• Saving ink and creating cleaner-looking documents

However, gridlines become essential when printing data tables, financial spreadsheets, or any document where readers need to follow information across rows and columns accurately.

For comparison, here's how to print gridlines in Google Sheets:

1. Open your Google Sheets document
2. Go to File > Print
3. In the print settings panel, scroll down to find Formatting
4. Check the box next to Show gridlines
5. Click Next to proceed with printing

Google Sheets integrates this setting directly into the print dialog, while Excel requires you to set it before accessing the print menu.

Always use Print Preview to verify your gridlines will appear correctly before sending your document to the printer:

1. Press Ctrl+P or go to File > Print
2. Examine the preview on the right side of the screen
3. Look for thin lines around cells - these indicate gridlines will print
4. Use the zoom controls to get a closer look at the gridlines
5. Navigate between pages using the arrow buttons to check all sheets

If you've enabled gridline printing but they still don't appear, check these common issues: Print Area Issues:

• Clear any custom print areas by going to Page Layout > Print Area > Clear Print Area
• Ensure your data falls within the printable area

Page Break Problems:

• Check for manual page breaks that might interfere with gridlines
• Go to Page Layout > Breaks > Reset All Page Breaks

Scaling Issues:

• Very small scaling percentages can make gridlines invisible
• Check your scaling settings in Page Layout > Scale to Fit
• Try setting scale to 100% to see if gridlines appear

Printer Settings:

• Some printers have settings that filter out light lines
• Check your printer preferences for line enhancement options
• Try printing in higher quality mode

If problems persist, try adding manual borders to important sections as an alternative to gridlines.