How to Print Excel Spreadsheet with Lines and Change Its Color

Get FREE Advanced Excel Exercises with Solutions!

Have you ever wanted to change the color of the gridlines in Excel or perhaps print the gridlines in your worksheet? Look no further since I will show you how to print a spreadsheet with lines and change its color in Excel.

Download Practice workbook


2 Ways to Print Excel Spreadsheet with Lines and Change Its Color

Here, I’ve taken a sample dataset to show you how you can print an Excel spreadsheet with lines and change its color.

How to Print Excel Spreadsheet with Lines and Change Its Color

Read More: What is spreadsheet and how it works


1. Using Excel Options to Print Excel Spreadsheet with Colorful Lines

You can use Excel Options to change the color of the gridlines to print the spreadsheet with colorful lines. By using two steps, I will describe to you the whole procedure.

Step 1: Changing Gridlines Color

Let’s begin with changing the Gridlines color. Excel gives us the option to change the color of the line as per your choice.

  • To begin with, select the File tab.

Using Excel Options to Change Excel Spreadsheet Color

  • Then, select Options.

A window of Excel Options will appear.

  • First, select Advanced.
  • Then, expand the Gridlines Color options then select any color of your choice. Here, I’ve selected the color Blue.
  • Finally, click OK.

Now, go back to your sheet and you will see the colorful lines.

Excel Spreadsheet with Colorful Lines


Step 2: Printing Excel Spreadsheet with Lines

Let me show you the way to print a spreadsheet with gridlines. There are several ways to print a sheet with gridlines. Here, I will use the most common way to do it.

  • First, go to the Page Layout tab >> then mark on Print from Sheet Options.

Using Page Layout tab to Print Excel Spreadsheet with Lines

  • Next, select the File tab.

  • Then, select Print and later click on the Print option.

Moreover, you will get your printed spreadsheet with colorful lines.

Note: To print the spreadsheet with colorful lines you have to use a color printer not black and white.


2. Use of Border Command to Print Spreadsheet with Lines and Change Its Color

Here is another way of changing the color of the gridlines and printing it.  The Border Commands allow us to change gridlines’ color by using colorful borders.

Step 1: Changing Gridlines Color

In this step, I will show you how you can change the gridline color by using the More Borders command.

  • At first, select the entire sheet or the page, or the dataset to apply borders.
  • Then, go to the Home tab >> expand Borders option >> then select More Borders.

Use of Border Command to Change Excel Spreadsheet Color

A dialog box of Format Cells will appear.

  • From there, expand the Color option >> then select any color of your choice.
  • Here, I selected the color Red.

  • Then, select Outline and Inside.
  • Finally, click on OK.

Therefore, you will get you spreadsheet with colorful lines.


Step 2: Printing Excel Spreadsheet with Colorful Lines

Let me show you another way of printing spreadsheets with lines.

Firstly, go to the Page Layout tab >> then mark on Print >> later click on Sheet Options arrow.

Use of Border Command to Print Excel Spreadsheet with Colorful Lines

A dialog box of Page Setup will appear.

  •  From there, select Print.

It will redirect you to the Print option.

Here, is the preview of your Excel spreadsheet with colorful gridlines.

As a result, you will be able to print excel spreadsheets with colorful lines.


Practice Section

You can practice the explained ways in the practice section of the uploaded Excel file.


Things to Remember

  • To print the spreadsheet with colorful lines you must use a color printer not black and white.

Conclusion

After reading this article you will be able to know how to print an Excel spreadsheet with lines as well as how to change gridline color. 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.

Further Readings

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Taryn Nefdt
Taryn Nefdt

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. She has over ten years of experience using Excel and Access to create advanced integrated solutions.

2 Comments
  1. 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.

    • Hi Tom Lynham

      Hope you are doing well. Here, I updated the article which implies the title and the explanation.

      By following above explained methods it is possible to print colorful gridlines but you must use a color printer.

      If this update doesn’t help you or you have further queries kindly let us know.

      Thanks
      Shamima Sultana

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo