Gridlines

B

Brian86

When I make the background to my worksheet a different color, I cant get the
gridlines to appear. I go through Excel options, choose Advanced and change
the color of the gridlines to black, yet no gridlines appear. Where might I
be going wrong?
 
J

JudithJubilee

Hi Brian,

The Gridline Option on the Advanced tab only changes the colour when there
is no background colour in the cells. If you want the gridlines to show
through a background colour you wil need to highlight the area and add
borders either using Format + Cells or the Borders icon next to Fill Colour.
 

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
How do I change the automatic color default in Excel 2007? 0
GRIDLINES 7 FILL COLOR 4
display gridlines with fill color 1
GRIDLINES 2
Gridlines in Office 2007 1
missing gridlines 2
Excell 2007 Gridlines and Automatic Colors 1

Top