How to change spreadsheet color lines in Excel

By default, the cell line colors in Excel have a rather fuzzy black color. If you work often for a long time, this color will be quite messy, or mistaken for the content. If so, you can change the color of the grid lines in the Excel table. You can change the default matte black color in the grid panel to your chosen colors. The following article will guide you how to change spreadsheet grid line colors in Excel.

How to format borders and background colors for Excel tables
4 basic steps to color alternating lines in Microsoft Excel
Instructions on how to create diagonal lines in Excel box

Video tutorial to change the color of Excel worksheet

How to change the spreadsheet color line on Excel

Step 1:

At the Excel interface you click on the Office icon and then click on Excel Options .

How to change spreadsheet color lines in Excel Picture 1

Step 2:

In the next interface click on the Advanced section, then you look to the right of Display options for this worksheet . In the Gridline Color section select the Excel grid line color according to your will to color the grid line.

Then press the OK button below to save.

How to change spreadsheet color lines in Excel Picture 2

Step 3:

After selecting the color we will see a new cell line color for Excel as shown.

How to change spreadsheet color lines in Excel Picture 3

To create a display cell area for Excel, we can select the area and then right click, click on Format Cells .

How to change spreadsheet color lines in Excel Picture 4

Step 4:

In the Format Cells dialog box, click the Border tab .

How to change spreadsheet color lines in Excel Picture 5

Next to the user select the type of line in the Style section. Then go to the Presets section and then click Outline then go to Inside to select the box for the entire selection. Note that if the user wants to change color from the grid line color, in the Color section, click on the color you like. Or to match the grid lines.

How to change spreadsheet color lines in Excel Picture 6

As a result, we will get the table with the highlighted colors as shown.

How to change spreadsheet color lines in Excel Picture 7

Depending on the user, we can choose different colors to change for Excel spreadsheet. This will make the Excel table look more eye-catching and clear.

See more:

How to use underline styles in Excel
A guide to the full Excel 2016 (Part 12): Page formatting and spreadsheet printing
How to create a password protection for Excel sheets

I wish you all success!

change the color of the Excel spreadsheet

Marvin Fry

Update 25 May 2019

You should read it

May be interested

MS Excel 2003 - Lesson 1: Get familiar with Microsoft Excel
excel 2003 spreadsheet has a maximum of 256 columns and 65,536 lines; the maximum number of worksheets you can add is 255 sheets. with this huge number, managing tables will become much simpler.
How to indent the line in Excel
when you enter data into a spreadsheet, excel automatically aligns with cells containing numbers to the right of the cell, and text input cells are automatically located to the left of the cell.
How to fix multiple lines in Excel
how to fix multiple lines in excel. in an excel spreadsheet with a long volume of information, containing multiple rows of columns, when you move your mouse down the bottom rows, the headlines are not displayed. in long tables, users need to keep the subject line fixed so that it is always displayed, even if you scroll down.
Instructions for deleting empty lines and columns in Excel 2016
sometimes your spreadsheet has too many blank lines and empty columns look very messy and lose aesthetics. to make the spreadsheet look better you can delete these blank lines and blank columns. however, instead of manually deleting each column, each blank line is very time-consuming, especially with long spreadsheets with many empty columns and empty lines.
How to print an Excel spreadsheet in a page
excel is a great useful spreadsheet program, but nothing is worse than creating a perfect spreadsheet and printing it on multiple sheets of paper that have pages with only one column or row. read this article and follow the tips below to get a nice print!
Excel with hidden lines - How to hide lines and display hidden lines in Excel
excel with hidden lines - how to hide lines and display hidden lines in excel. sometimes in the process of working, processing data in excel, you need to hide / show the line in excel. if you do not know how to hide lines and display hidden lines in excel, please refer to article vi
Instructions for inserting a PDF file into Excel spreadsheet
if you're having trouble inserting a pdf file into an excel spreadsheet and you don't know how to do it. inserting pdf files into excel spreadsheets is not as simple as you think. in the article below, network administrator will guide you through the steps to insert a pdf file into excel spreadsheet.
6 ways to fix Excel error not displaying spreadsheet content
sometimes you open an excel spreadsheet but you don't see it, but a blank gray window. you wonder if excel has any errors or have any operations wrong when opening a spreadsheet.
Instructions on how to change border color in Excel
when you create a border in excel, the default color of the border will be gray. however, you can also change the border color to the color you want.
How to send email from Excel spreadsheet with VBA script
sending emails from microsoft excel requires only a few simple scripts. add this function to a spreadsheet and you can really make the most of all features in excel.