Printing Cell Borders in Excel 2010

Microsoft Excel 2010’s default setup is ideally suited for viewing on a computer screen. The interface is clean and easy to understand, and you can generally infer from the different menus what you need to do to make your desired changes. However, the default settings for printed Excel spreadsheets are not as perfect as they could be. This problem is especially prevalent in circumstances where you are printing out a lot of data that fills an entire sheet. It can be very difficult to trace which row or column a particular cells belongs in, which can lead to confusion over the data that is being read. You can achieve a solution to this dilemma, however, by printing cell borders in your Excel 2010 spreadsheet. This improves the organization of your printed data by incorporating the grid pattern that you see in the spreadsheet on your computer screen.


How to Print Gridlines in Excel 2010


The technical term for the effect that you want on your printed spreadsheet is gridlines. By enabling this setting on the Page Setup menu you will print the series of horizontal and vertical lines that help your readers keep track of the data cells that they are viewing. I have been checking this option in my Excel spreadsheets for years, as have most of the other people that I work with. I honestly don’t know why this isn’t the default option, but that is the opinion from my perspective. I’m sure there are other people that use Excel who dislike or have their own reasons for not printing gridlines.

Begin by double-clicking your Excel spreadsheet to open the file in Excel 2010.

Click the Page Layout tab at the top of the window.

click the page layout tab in excel 2010


Click the tiny Page Setup button at the bottom-right corner of the Page Setup section of the ribbon. This opens a new window titled Page Setup.

expand the excel page setup menu


Click the Sheet tab at the top of this Page Setup window.

adjust the sheet settings in excel 2010


Check the box to the left of Gridlines, then click the OK button at the bottom of the window.

printing excel borders in excel 2010


You should familiarize yourself with this menu, as it also contains many of the other options that you will need to adjust to configure printing for your Excel spreadsheet. Navigate through the assorted Page Setup menu tabs to find options for adjusting your Margins, Page Orientation and Header/Footer. You can also configure your Excel document so that the top row displays at the top of every printing page, which is a helpful option for multiple page documents. Read this article to learn how to use that feature. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.