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.
Changing the color of the gridlines 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.
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.
The title of this article implies that you can change the color of the gridlines and have them print in color. In fact, this is not possible. You outline two completely separate options that do not work together. It is possible to display gridlines ON SCREEN in a different color, but simply turning on the “Print Gridlines” in the print dialog PRINTS them in black.