Related: 15 Fun Excel Project Ideas To Boost Your Creativity 2. If your spreadsheet looks as you want it to, press the 'Print' button. To make sure that your spreadsheet can now print with gridlines, navigate to 'File,' then 'Print,' to see the Print Preview screen. Under 'Gridlines,' check the box next to the option for 'Print.' The Sheet Options box contains two subheadings of features: one for Gridlines and one for Headings. Go to the navigation bar at the top of the screen and choose the tab that reads 'Page Layout.'įind the group of features labeled 'Sheet Options.' Following are four steps for using 'Sheet Options' to print gridlines in Excel: The features included in Excel's 'Sheet Options' offer users the fastest method for printing spreadsheets with gridlines. How to print gridlines for Excel using 'Sheet Options' Following are four distinct methods for setting up Excel gridlines that you can print: 1. The best method can depend on a few factors, such as what version of Excel you have and whether you prefer using dialog boxes. Related: How To Graph Functions in Excel (With Tips and FAQ) How to set up gridlines to print in ExcelĮxcel offers its users several methods for establishing gridlines that theycan print. Printing with gridlines in this type of situation may help others reviewing the spreadsheets to easily interpret and extract meaning from the distinct data contained in each row or column. It can be a good idea to print with gridlines when you have large amounts of data contained on a spreadsheet.

Luckily, Excel gives users the ability to print with gridlines if they want. When to print gridlines in Excelīy default, gridlines don't appear when you print your Excel spreadsheets. The gridlines make it easier for both you and others to quickly scan and understand the data on your spreadsheet. Excel automatically applies these gridlines to every spreadsheet you create within the program. Gridlines in Excel are the lines separating cells of data. Related: How To Sort Tables in Excel in 4 Steps (With Tips) What are gridlines in Excel? In this article, we explain what Excel gridlines are, discuss when you may want to print gridlines, explore four methods for doing so in Excel and offer advice on troubleshooting issues that may arise when performing this task. Since the default for this program is to print without gridlines, knowing the various methods for printing in Excel with gridlines can make it easier for others to read and understand your spreadsheets. If you're printing Excel spreadsheets, you may want to print them with gridlines. Many professionals use Excel to help them create, organize and evaluate data related to the company for which they work.

Print gridlines in powerpoint