Printing spreadsheets in Excel often results in unwanted gridlines showing up on your printed pages, which can make your documents look cluttered or unprofessional. If you want a clean, crisp printout without the gridlines, this guide walks you through the simple steps to achieve that in Office 365. Whether you’re preparing a report, a presentation, or just a clean copy for sharing, removing lines ensures your document looks polished and neat. Before starting, ensure you have your Excel file open and ready to modify.
What You’ll Need
- An active Microsoft Office 365 subscription with Excel installed
- The Excel workbook or worksheet you wish to print without gridlines
Step-by-Step
- Open your Excel workbook and navigate to the worksheet you want to print.
- Go to the **Page Layout** tab on the Ribbon at the top of Excel.
- In the **Sheet Options** group, locate the **Gridlines** section.
- Uncheck the box labeled **View** under **Gridlines**. This action hides gridlines from view on your worksheet.
- Next, to ensure gridlines do not print, look for the **Print** checkbox within the same **Gridlines** section.
- Uncheck the **Print** box. This step is crucial; it prevents gridlines from appearing on the printed version.
- Optionally, you can verify your print settings by going to the **File** tab and selecting **Print**. In the print preview, confirm that gridlines are not visible.
- Adjust any other print settings as needed, such as orientation, margins, or scaling.
- Click **Print** to generate your printout without gridlines.
Common Mistakes
- Forgetting to uncheck the **Print** box under **Gridlines** — this is a common oversight that causes gridlines to still appear on the printed page.
- Confusing the **View** option with the **Print** option; remember, hiding gridlines from view does not automatically remove them from printing.
- Not checking the print preview before printing, which can lead to unexpected results.
- Applying formatting to cells that visually resemble gridlines, which can be mistaken for actual gridlines — these need to be removed separately if desired.
Tips
- If you want some gridlines to be visible in the worksheet but not on the printout, ensure the **Print** checkbox remains unchecked while keeping the **View** box checked.
- To quickly toggle gridlines, you can use the shortcut: press **Alt**, then **P**, then **V**, then **G** to toggle gridlines visibility.
- Consider using cell borders instead of gridlines if you want more control over which lines appear on print.
- Save your worksheet before making print-related changes to avoid losing previous formatting or settings.
Troubleshooting
If gridlines still appear on your printed document after following the steps:
- Revisit the **Page Layout** tab and double-check that both **View** and **Print** options under **Gridlines** are unchecked.
- Ensure no cell formatting includes border lines that mimic gridlines. If borders are applied, select the affected cells, go to the **Home** tab, click **Borders**, and choose **No Border**.
- Check your print preview again to verify changes before printing.
- If using a print driver or third-party printing software, ensure it does not override Excel settings.
- Restart Excel and try the process again if changes do not seem to apply.
Frequently Asked Questions
1. Will hiding gridlines affect how I view the worksheet on screen?
No, hiding gridlines only affects the printout. Your worksheet view remains unchanged unless you also hide gridlines from view.
2. Can I keep gridlines visible on screen but print without them?
Yes, uncheck **Print** under **Gridlines** in the **Page Layout** tab, while keeping **View** checked. This way, gridlines are visible on your screen but do not print.
3. How do I remove cell borders that look like gridlines?
Select the cells with borders, go to the **Home** tab, click **Borders**, and choose **No Border** to remove them from the worksheet.
4. Why do my gridlines still appear after following these steps?
This might be due to cell borders or print settings overriding Excel’s gridline options. Double-check both the **Page Layout** settings and cell formatting.
5. Can I save a preset for printing without gridlines for future use?
Yes, you can set your print preferences and save the worksheet template for consistent use in future projects.
6. Does this method work in older versions of Excel?
The process is similar in older Excel versions, but menu locations may vary slightly. Look for **Gridlines** options under **Page Layout** or **View** menus.
By following these detailed steps, tips, and troubleshooting advice, you can easily print your Excel worksheets without the distracting gridlines, resulting in cleaner, more professional-looking documents that suit your presentation needs.
Related
- How to Make Your iPhone Louder During Calls Expert Tips
- How to Make iPhone Internet Faster Tips and Tricks
- How to Change Screen Color on iPad for Custom Effects