Default Gridlines/Cell Border Colors

P

Paul

By default the gridlines on a worksheet and any borders
that you put around cells are the same color - black. If
you change the gridline colors using Tools - Options -
View all the cell borders that you have created also
change color. Is this a way to change the color of the
gridlines in a worksheet and keep the default color for
cell borders black?
 
J

Jim Rech

Is this a way to change the color of the gridlines in a worksheet and keep
I don't believe so. The automatic color for borders is whatever the color
for gridlines is, unless the color for gridlines is default. When the color
for gridlines is default then the default color for borders is the color for
"font" under Windows Display Properties, Appearance, Advanced, Window. This
is black by default but you can change it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank Sheet with Gridlines 11
GRIDLINES 2
Need help modifying code 0
Gridlines 1
default gridlines style 2
cell color versus gridlines - Excel 2003 1
display gridlines with fill color 1
Excel2007 4

Top