How to Print Excel Spreadsheet with Grid Lines and Change its Color
Last updated on May 17th, 2018
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.
Table of Contents
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.
1) In order to change the default appearance of the grid lines, go to File>Options as shown below.
2) Select Advanced and scroll down until you get to the Display options for this worksheet section as shown below.
3) Click on the drop-down arrow next to Gridline color and choose a new color, in this case, we’ll select Orange.
4) Click Ok and the effect of setting the gridline color to orange is shown below.
Read More: What is spreadsheet and how it works
How to Print Excel Spreadsheet with Lines
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.
2) Go to Page Layout>Sheet Options and under Gridlines check the Print option as shown below.
3) Going to File>Print, in order to see the Print Preview, should now show that the gridlines will also print as shown below.
And there you have it.
Read More:
Change the color of text and background of cells – An Excel Font and Fill Color Complete Guide
How to Convert Text to Numbers in Excel
How to Format an Excel Spreadsheet for Printing
What is Spreadsheet in MS Excel
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
She has over ten years of experience using Excel and Access to create advanced integrated solutions.
