✦Template Printable Ideas Insights

Print Excel with Gridlines: A Step-by-Step Guide

By

Gridlines serve a crucial purpose in Excel by providing a visual reference, making it easier to understand and edit spreadsheet data. However, by default, they are not printed. If you want gridlines to appear on your printed Excel sheets, you'll need to enable them. Here's how to do it using Microsoft Excel.

Whether you're printing a financial report or a shopping list, gridlines can make the content more readable, especially when dealing with numbers or complex data. Let's dive into the steps to get gridlines on your printed Excel pages.

Enabling Gridlines for Print

Starting from Excel 2007 onwards, gridlines are not printed by default to save ink. But don't worry, you can easily enable them for printing. Here's how:

an excel spreadsheet showing how to use the balance sheet in microsoft's workbook
an excel spreadsheet showing how to use the balance sheet in microsoft's workbook
How to print gridlines with Excel 2013
How to print gridlines with Excel 2013
How to print gridlines in Excel
How to print gridlines in Excel

1. **Open the Print dialog box:** Go to the 'File' menu, then 'Print', or simply press 'Ctrl + P' (Windows) or 'Command + P' (Mac).

Page Setup Options

2. **Access Page Setup:** In the Print dialog box, click on the 'Page setup' dialog launcher (the small icon at the bottom right).

Excel Worksheet Printing Tips - Printing Problem Fixes
Excel Worksheet Printing Tips - Printing Problem Fixes
How do I print the gridlines in my spreadsheet in Excel 2007, 2010 and 2013?
How do I print the gridlines in my spreadsheet in Excel 2007, 2010 and 2013?
Guide: Print Blank Grid lines On Excel Sheet
Guide: Print Blank Grid lines On Excel Sheet

3. **Enable gridlines:** In the 'Page Setup' window, under the 'Sheet' section, check the box next to 'Print gridlines'.

Customize Print Area

4. **Specify print area:** If you want to print only a specific range, use the 'Selection: Whole sheet' dropdown to choose your desired range. Alternatively, manually select the cells you want to print.

5. **Adjust other settings:** You can also customize other print settings like scaling, orientation, and more under the 'Margins', 'Paper', and 'Scaling' sections.

How to Print Gridlines in Excel - A Step-By-Step Guide
How to Print Gridlines in Excel - A Step-By-Step Guide
Printing in Excel 1 - Print the Gridlines when an Excel Spreadsheet is Printed
Printing in Excel 1 - Print the Gridlines when an Excel Spreadsheet is Printed
How to Format Your Excel Spreadsheets (Complete Guide) | Envato Tuts+
How to Format Your Excel Spreadsheets (Complete Guide) | Envato Tuts+
How to Print Gridlines in Excel
How to Print Gridlines in Excel
How to print blank worksheet with gridlines in Excel?
How to print blank worksheet with gridlines in Excel?
How to Show/Hide Grid Lines in Excel - Grids Not Showing Up in Excel Worksheet - NO ADS
How to Show/Hide Grid Lines in Excel - Grids Not Showing Up in Excel Worksheet - NO ADS

6. ** Preview and print:** After adjusting the settings, click 'OK' to return to the Print dialog box. Here, you can preview your print settings and then proceed with printing.

Enabling Gridlines for All Future Prints

If you regularly need to print Excel worksheets with gridlines, you can enable them by default for all future prints:

1. Follow steps 1 through 3 as mentioned above to open the 'Page Setup' window.

Change the Gridline Color in Excel Spreadsheets - 2 Ways!
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
How To Print Gridlines in Excel
How To Print Gridlines in Excel
How to print in Excel with lines - Excel Wizard
How to print in Excel with lines - Excel Wizard

2. **Set gridlines as default:** At the bottom of the window, click 'Set as Default'.

3. **Confirm and close:** Click 'Yes' in the confirmation dialog box, then 'OK' to close the 'Page Setup' window.

Now, gridlines will be printed by default for all your Excel prints until you change the setting again.

Tips for Printing Large Spreadsheets

Before you print, make sure to check the following tips to ensure the best print results:

1. **Format your data:** Make sure your data is well-structured and formatted before you print. Use headings, borders, and conditional formatting to enhance readability.

2. **Reduce page size and margins:** Smaller page size and reduced margins can fit more data on a single page, saving paper.

3. **Print in black and white:** If possible, print in black and white to save ink and ensure clear print quality.

Gridlines can significantly improve the readability of your printed Excel sheets. Now that you know how to enable them, you can ensure your prints are clear and easy to understand.