3 Ways to Use Excel Gridlines

Excel gridlines are an easy way to quickly spruce up your spreadsheet. Not only are they a great way to draw attention to particular areas of your spreadsheet, Excel gridlines can also aid you when you are inputting data into your workbook. Excel makes it easy to turn the gridlines on and off and also to change the way they look, which allows you maximum flexibility. This makes Excel gridlines readily adaptable to almost any application.

1. The Default View

Most people are already familiar with the default view of Excel gridlines. The familiar light grey grid makes it easy to organize and analyze data and is best suited for simple data entry or analysis projects or for situations where you won’t be presenting the spreadsheet to an external customer. So, for simple, internal projects, you probably won’t see a need to change the gridline appearance from the default view.

2. Vanishing Excel Gridlines

However, if you are planning on presenting your data analysis to an external customer or client and want to convey a slightly cleaner appearance, you can simply turn the gridlines off. To do this, go into the View Tab, and under the Show group, uncheck the box next to “Gridlines”. Your spreadsheet will then look like this.

Excel Gridlines

As you can see, once you uncheck that box, Excel removes the gridlines from the sheet, which allows you to present your data against a white background (though you can change the color if you wish). This is an easy way to make a clean, professional data analysis presentation.

3. Border Settings

If you want to do something a little more complicated than simply turning the gridlines on and off, you can do that through Excel’s border settings, which are found on the Home Tab in the Font group.

Excel Gridlines Borders

Using this menu of options, you can change the thickness of the gridlines, their colors, change them into dashes, symbols, etc. These options allow you the ability to change any aspect of the gridlines that you want, allowing you maximum freedom to customize them to fit any situation. These features are mostly valuable where unique formatting is necessary to emphasize the underlying data analysis and is very useful when you are getting ready to present your data

To learn more helpful Excel tips and tricks, be sure to sign up for our free newsletter! You’ll get free help articles directly in your inbox and be among the first to receive exclusive discounts to our training classes.