✦Template Printable Ideas Insights

How to Get Excel to Print with Lines

By

Ever found yourself frustrated with Excel printouts that lack gridlines, making your meticulously organized data look like a jumbled mess? Don't worry, you're not alone. By default, Excel doesn't print gridlines, but with a few simple steps, you can make your spreadsheets easier to read when printed.

Let's dive into how to get Excel to print with lines, ensuring your data stays as organized on paper as it is on screen.

Before You Begin: A Quick Word on Printer Settings

Before we begin, ensure your printer settings are configured correctly. Sometimes, printers can override Excel's print settings, so double-check your printer's properties to avoid any surprises.

Print Sheets in Excel
Print Sheets in Excel
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
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

Now, let's get started with customizing Excel's print settings.

Print Area vs. Entire Sheet

Before activating the gridlines, decide whether you want to print the entire sheet or just a specific area. To select a print area, highlight the cells you want to print before following the steps below. If you want to print the entire sheet, skip this step.

How to print top row on every page in Excel
How to print top row on every page in Excel
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
Progress Tracker in Excel‼️ #excel
Progress Tracker in Excel‼️ #excel

To select a print area, click and drag your cursor over the cells you want to print, then press 'Ctrl + A' to select everything. To deselect any unwanted cells, right-click and uncheck the '++] Visible' option.

Activating Gridlines in Excel

Now, let's activate the gridlines. Follow these steps:

1. Click on 'File' in the ribbon, then select 'Print'. Alternatively, press 'Ctrl + P'.

Excel Not Printing Gridlines: Here's Why & How to Fix It
Excel Not Printing Gridlines: Here's Why & How to Fix It
Simple Excel Practice Exercise for Beginners
Simple Excel Practice Exercise for Beginners
How to enter multiple lines in a single Excel cell
How to enter multiple lines in a single Excel cell
How to Make a Line Graph in Excel
How to Make a Line Graph in Excel
an excel spreadsheet with the text, how to use e - signature in excel
an excel spreadsheet with the text, how to use e - signature in excel
excel basics tutorial
excel basics tutorial

2. In the 'Print' window, click on the 'Page setup' link at the bottom.

3. Under the 'Sheet' tab, check the box next to 'Gridlines'.

4. Click 'OK' to close the 'Page setup' window, then click 'Print' in the 'Print' window to preview your printout.

How to wrap text in Excel automatically and manually
How to wrap text in Excel automatically and manually
How to Make Your Own Graphs - Lindsay Bowden
How to Make Your Own Graphs - Lindsay Bowden
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets

Adjusting Print Scale for Better Results

Printing gridlines is a great start, but without the right scale, your printout might be too small or too large. Let's fine-tune your printout by adjusting the scale.

Excel allows you to adjust the scale for both columns and rows independently. Here's how:

Adjust Column Width

1. Place your cursor where you want the printed columns to start. Excel will display the column width for that column in the 'Print area' section of the 'Print' window.

2. Click on the small, double-headed arrow that appears next to the column width and drag it to adjust the width.

Adjust Row Height

The process for adjusting row height is similar to that for column width:

3. Place your cursor where you want the printed rows to start. Excel will display the row height for that row in the 'Print area' section of the 'Print' window.

4. Click on the small, double-headed arrow that appears next to the row height and drag it to adjust the height.

Printing in Landscape or Portrait Orientation

Sometimes, your data might be wider than it is tall, making landscape orientation more suitable. Conversely, tall data works best in portrait orientation. Let's adjust the orientation for the perfect printout.

Changing to Landscape Orientation

Follow these steps to change the orientation:

1. Click on 'Page layout' in the 'Print' window.

2. In the 'Orientation' group, click on 'Portrait' to switch to landscape orientation.

Changing to Portrait Orientation

If your data is taller than it is wide and you've chosen landscape orientation, simply follow these steps to switch back to portrait:

1. Click on 'Portrait' in the 'Orientation' group to switch to portrait orientation.

And there you have it – a perfectly printed Excel sheet with lines, the right scale, and orientation. Happy printing!