How to print excel with lines
Tutor 5 (120 Reviews)
Excel Tutor
Still stuck with a Excel question
Ask this expertAnswer
To print Excel with lines, you need to enable gridlines in the print settings before printing your spreadsheet.
Understanding Gridlines vs. Borders
Gridlines are the faint gray lines that appear between cells in Excel's normal view. These lines help you see cell boundaries while working but don't print by default. Borders are formatting elements you manually add to cells that always print when included.
Steps to Print with Gridlines
Method 1: Using Page Layout Tab
- Open your Excel worksheet
- Click the "Page Layout" tab in the ribbon
- Navigate to the "Sheet Options" group
- Under "Gridlines," check the "Print" checkbox
- Click "File" then "Print" to print your document
Method 2: Using Page Setup Dialog
- Click the "Page Layout" tab
- Click the small arrow in the bottom-right corner of the "Page Setup" group
- Select the "Sheet" tab in the dialog box
- Check "Gridlines" under the "Print" section
- Click "OK" to apply changes
- Print your document using Ctrl+P (Windows) or Cmd+P (Mac)
How to Print Excel with Lines
To print Excel with lines, you need to enable gridlines in the print settings before printing your spreadsheet.
Understanding Gridlines vs. Borders
Gridlines are the faint gray lines that appear between cells in Excel's normal view. These lines help you see cell boundaries while working, but don't print by default. Borders are formatting elements you manually add to cells that always print when included.
Steps to Print with Gridlines
Method 1: Using Page Layout Tab
- Open your Excel worksheet
- Click the "Page Layout" tab in the ribbon
- Navigate to the "Sheet Options" group
- Under "Gridlines," check the "Print" checkbox
- Click "File" then "Print" to print your document
Method 2: Using Page Setup Dialog
- Click the "Page Layout" tab
- Click the small arrow in the bottom-right corner of the "Page Setup" group
- Select the "Sheet" tab in the dialog box
- Check "Gridlines" under the "Print" section
- Click "OK" to apply changes
- Print your document using Ctrl+P (Windows) or Cmd+P (Mac)
Adding Borders for Guaranteed Line Printing
Borders provide more control over which lines print and their appearance.
Quick Border Application
- Select the cells where you want lines
- Click the "Home" tab
- Find the "Borders" button in the "Font" group (looks like a square divided into four)
- Click the dropdown arrow next to the Borders button
- Select "All Borders" for lines around and between all selected cells
Custom Border Options
- Select your desired cells
- Right-click and choose "Format Cells" (or press Ctrl+1 on Windows, Cmd+1 on Mac)
- Click the "Border" tab
- Choose line style, color, and thickness
- Click preset options or manually click border placement areas
- Click "OK" to apply
- Press Ctrl+P (Windows) or Cmd+P (Mac)
- Review the preview pane on the right
- Verify gridlines or borders display as expected
- Adjust settings if lines don't appear
- Use borders for important documents requiring a consistent line appearance
- Apply gridlines for draft prints or internal working documents
- Test print a single page before printing large documents
- Save printer ink by using thinner line styles when appropriate
- Create a template with your preferred line settings for repeated use
Print Preview Verification
Always check your print preview before printing to ensure lines appear correctly.
Troubleshooting Missing Lines
Gridlines Not Showing
The "Draft quality" option in Page Setup may be enabled. Disable this option in the Page Setup dialog under the "Sheet" tab.
Faint or Unclear Lines
Printer settings may need adjustment. Access printer properties through the Print dialog and increase print quality or darkness settings.
Partial Gridline Printing
Some cells may have a white fill color applied. Remove fill color by selecting cells, clicking the "Fill Color" button in the Home tab, and choosing "No Fill."
Differences Between Windows and Mac
Windows: Access Page Setup through the Page Layout tab or by pressing Alt+P+S+P. The Print Preview integrates directly into the Print dialog (Ctrl+P).
Mac: Page Setup exists as a separate menu option under File > Page Setup. Print Preview appears automatically when selecting File > Print (Cmd+P). The Sheet Options group in the Page Layout tab remains in the same location.
Best Practices for Line Printing
Get Online Tutoring or Questions answered by Experts.
You can post a question for a tutor or set up a tutoring session
Answers · 1
How to track changes in excel
Answers · 1
How to lock certain cells in excel
Answers · 1
How to merge two excel spreadsheets
Answers · 1
Where is the name box in excel
Answers · 1