How to Print Excel Spreadsheet with Lines and Change Its Color

Download the Practice workbook


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

We have a sample dataset to show how to 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


Method 1 – Using Excel Options to Print the Excel Spreadsheet with Colorful Lines

Step 1 – Changing the Gridline Colors

  • Select the File tab.

Using Excel Options to Change Excel Spreadsheet Color

  • Select Options.

A window for Excel Options will appear.

  • Select Advanced.
  • Expand the Gridlines Color options then select any color of your choice. We’ve selected the color Blue.
  • Click OK.

Go back to your sheet and you will see the colorful lines.

Excel Spreadsheet with Colorful Lines


Step 2 – Printing the Excel Spreadsheet with Lines

  • Go to the Page Layout tab and check Print under Gridlines from Sheet Options.

Using Page Layout tab to Print Excel Spreadsheet with Lines

  • Select the File tab.

  • Select Print and click on the Print option.

You will get your printed spreadsheet with colorful lines.

Note: To print the spreadsheet with colorful lines you have to use a color printer. You can also print as PDF or other file types.


Method 2 – Use the Border Command to Print a Spreadsheet with Lines and Change Its Color

Step 1 – Changing the Border Colors

  • Select the entire sheet or the dataset to apply borders.
  • Go to the Home tab, expand the Borders option, then select More Borders.

Use of Border Command to Change Excel Spreadsheet Color

A dialog box for Format Cells will appear on the Border tab.

  • Expand the Color option, then select any color of your choice. We selected the color Red.

  • Select Outline and Inside.
  • Click on OK.

The spreadsheet will get colored borders.


Step 2 – Printing the Excel Spreadsheet with Colorful Lines

  • Go to the Page Layout tab, check Print under Gridlines, and click on the Sheet Options arrow (dialog launcher).

Use of Border Command to Print Excel Spreadsheet with Colorful Lines

  • Select Print.

It will redirect you to the Print option. Here is the preview of your Excel spreadsheet with colorful gridlines.

Here’s the printed sheet.


Practice Section

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


Further Readings

Get FREE Advanced Excel Exercises with Solutions!
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