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.
Step 3: Check the box to the left of Print under Gridlines in the Sheet Options section at the top of the window.
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.
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.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.