How to Print Excel Spreadsheet with Grid Lines and Change its Color

Have you ever wanted to change the color of the gridlines in Excel or perhaps print the gridlines in your worksheet? Well, look no further, since we will show you how to do just that.

Read More: What is spreadsheet and how it works

Changing the color of the grid lines in the worksheet

When you open an Excel workbook, you usually get the default display below and the gridlines formatted in the worksheet, in the following way.

Change grid line colors in Excel - Image 1

1) In order to change the default appearance of the grid lines, go to File>Options as shown below.

Change grid line colors in Excel - Image 2

2) Select Advanced and scroll down until you get to the Display options for this worksheet section as shown below.

Change grid line colors in Excel - Image 3

3) Click on the drop-down arrow next to Gridline color and choose a new color, in this case, we’ll select Orange.

Change grid line colors in Excel - Image 4

Change grid line colors in Excel - Image 5

4) Click Ok and the effect of setting the gridline color to orange is shown below.

Change grid line colors in Excel - Image 6

How to Print Excel Spreadsheet with Lines

Read More: Change the color of text and background of cells – An Excel Font and Fill Color Complete Guide

1) We have some data in a worksheet as shown below and we’d like to print the gridlines in the worksheet as well within the range of the data.

How to Print Excel Spreadsheet with Lines - Image 1

2) Go to Page Layout>Sheet Options and under Gridlines check the Print option as shown below.

How to Print Excel Spreadsheet with Grid Lines - Image 2

3) Going to File>Print, in order to see the Print Preview, should now show that the gridlines will also print as shown below.

How to Print Excel Spreadsheet with Grid Lines - Image 3

Read More: What is Spreadsheet in Excel

And there you have it.

Download Excel File

How-To-Change-Gridline-Color-And-Print-Gridlines

Conclusion

You can easily change the color of the gridlines of the worksheet at hand or print the gridlines in a worksheet if you so choose too, in Excel.

Please feel free to comment and tell us if you frequently change the color of the gridlines in your worksheets or if you print gridlines.

Useful Links

How to Print Gridlines in a Workbook

Taryn is a Microsoft Certified Professional, who has used Office Applications such as Excel and Access extensively, in her interdisciplinary academic career and work experience. She has a background in biochemistry, Geographical Information Systems (GIS) and biofuels. She enjoys showcasing the functionality of Excel in various disciplines.

In her spare time when she’s not exploring Excel or Access, she is into graphic design, amateur photography and caring for her two pets, Pretzel and Snoopy.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

Solve the Math * Time limit is exhausted. Please reload CAPTCHA.