Gridlines disappear when using "Fill"

C

Chip Pearson

That is the way Excel works. The fill color overlays the gridlines. Add
borders to the cells to make your own "gridlines"
 
G

Guest

I thought there might be another way. I tried that but it's cumbersome with
a large spreadsheet. Thanks!
 
D

Dave Peterson

You can create a toolbar that contains lots of border options.

Tools|Customize|toolbars tab|create a new toolbar
Then on the Commands tab, select Format category
Drag all the border icons you find to this new toolbar.
 

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

GRIDLINES 7 FILL COLOR 4
Gridlines disappear when I use color fill 6
display gridlines with fill color 1
print gridlines when using fill color 1
Blank Sheet with Gridlines 11
missing gridlines 2
Gridlines Hidden by Shading 1
gridlines won't display 1

Top