✦Template Printable Ideas Insights

Print Excel with Lines: Step-by-Step Guide

By

Ever found yourself in need of adding lines or borders to your Excel prints to make your data more organized and easier to read? You're not alone. Excel, with its vast array of formatting options, allows you to do exactly that. So, can you print Excel with lines? The short answer is yes, and it's surprisingly simple when you know how.

The default print setting in Excel is to exclude gridlines, but you can easily change this to include lines, or even custom borders. Let's dive into the step-by-step process.

Adding Lines to Your Excel Print

Adding lines to your Excel print is a two-step process: setting your print area and then adjusting your print settings to include the lines.

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
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
45+ Paper Templates & Samples - DOC, PDF, Excel
45+ Paper Templates & Samples - DOC, PDF, Excel

The first step is to select the data range you want to print. This can be done by clicking and dragging your mouse across the cells, or by using the keyboard shortcut Ctrl + A (Windows) or Command + A (Mac) to select the entire sheet. Once you've selected your data, go to the 'File' menu, then 'Print Area', and select 'Set Print Area'.

Printing Gridlines

Now that your print area is set, it's time to switch on the gridlines. In the 'Page Layout' tab, you'll find the 'Print Area' group. Click on the small arrow at the bottom right of the 'Print Area' box and select 'Print Selected area'. Now, note the 'Print' group, where you'll find the 'Gridlines' option. Click the checkbox to select it. Your selected area will now show gridlines, which will also print.

Progress Tracker in Excel‼️ #excel
Progress Tracker in Excel‼️ #excel
an info sheet with different types of graphs and numbers on the bottom right hand corner
an info sheet with different types of graphs and numbers on the bottom right hand corner
Bookkeeping Spreadsheets, The 5 Best Websites to Download Free Excel Templates 💵
Bookkeeping Spreadsheets, The 5 Best Websites to Download Free Excel Templates 💵

Gridlines serve as simple borders around each cell. If you want more control over your lines, you might want to use cell borders.

Printing with Cell Borders

To print with cell borders, select the range you want to format. In the 'Home' tab, click on 'Borders' in the 'Font' group. Choose the border style you want, or click 'More Borders...' for more options. Once you're happy with your selection, click 'OK'.

The selected cells will now have borders. To print these borders, go back to the 'Page Layout' tab and check the 'Print' box in the 'Format' section. Your selected cells will now print with borders.

7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
the microsoft excel overview is shown in this hand - written document, with instructions to use it
the microsoft excel overview is shown in this hand - written document, with instructions to use it
a notebook with microsoft excel written on it
a notebook with microsoft excel written on it
📊 Excel Sikhna Chahte Ho? To Sabse Pehle Iska Interface Samjho!
📊 Excel Sikhna Chahte Ho? To Sabse Pehle Iska Interface Samjho!
Excel - Link Data Between Worksheets In A Workbook In Excel
Excel - Link Data Between Worksheets In A Workbook In Excel
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
Change the Gridline Color in Excel Spreadsheets - 2 Ways!

Printing Specific Ranges with Lines

What if you want to print only certain ranges with lines? You can do this by inserting a table. Go to the 'Insert' tab and click on 'Table'. Ensure that your data meets the criteria for a table, then click 'OK'.

With your table inserted, you can apply borders around certain ranges within the table. Once your borders are set, select the range you want to print, go to the 'Page Layout' tab, and choose 'Print' from the 'Format' section. Only the selected range will print with lines.

Printing Multiple Sheets with Lines

Sometimes, you might need to print multiple sheets with lines. You can select all the sheets you want to print by holding down the Ctrl key (Windows) or Command key (Mac) on your keyboard and clicking on each sheet tab. Once you've selected all the sheets, go to the 'Page Layout' tab and adjust your print settings as desired.

Excel Not Printing Gridlines: Here's Why & How to Fix It
Excel Not Printing Gridlines: Here's Why & How to Fix It
how to print a large excel spreadsheet on one page
how to print a large excel spreadsheet on one page
From Blank Sheet to Fully Functional Roster
From Blank Sheet to Fully Functional Roster

Remember to use the 'Print Active Sheets' option when printing multiple sheets. This way, only the selected sheets will print, rather than every sheet in your workbook.

Incorporating lines into your Excel prints can significantly enhance the readability of your data. Whether you're using gridlines, cell borders, or printing specific ranges, Excel has got you covered. So, the next time you need to print Excel with lines, you'll know exactly how to do it.