How to Print the Lines On Your Excel 2013 Spreadsheet

Microsoft Excel 2013 is one of the leading choices when you need to store data so that it can be analyzed and compared. But it is a program that is primarily meant to be viewed on a computer screen, and can be very difficult to work with when you need to print a spreadsheet. There are ways to change your print settings to fit a spreadsheet on a printed page more easily, which can solve part of the problem, but the default print setting is not going to include the gridlines that separate your data cells. This can be very difficult to read and organize visually, which can lead to mistakes and misinterpretation. Fortunately you can set up your Excel spreadsheet so that those lines are displayed when the document is printed.


Print Gridlines in Excel 2013

It’s always a good idea to check the Print Preview screen before you hit the Print button. This will give you an idea of how the printed document will look, plus it will tell you the number of pages that are about to be printed. Excel spreadsheets have a bad habit of barely extending onto another page, which can lead to a lot of unnecessary wasted pages being printed.


Step 1: Open your spreadsheet in Excel 2013.


Step 2: Click the Page Layout tab at the top of the window.

click the page layout tab



Step 3: Check the box to the left of Print under Gridlines in the Sheet Options section at the top of the window.

how to print the lines on your spreadsheet in excel 2013



You can then press Ctrl + P on your keyboard to open the Print window, then click the Print button at the center of the window.

click the print button in the print window



You can also make printing even easier by forcing the spreadsheet to fit on one page. Note, however, that this method will shrink the spreadsheet to fit on one page, no matter how large it is, which can make large spreadsheet unreadable.

Recent Articles