Gridlines disappear when using "Fill"

  • Thread starter Thread starter Guest
  • Start date Start date
That is the way Excel works. The fill color overlays the gridlines. Add
borders to the cells to make your own "gridlines"
 
I thought there might be another way. I tried that but it's cumbersome with
a large spreadsheet. Thanks!
 
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.
 
You must log in or register to reply here.

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 disappear when I use color fill 6
GRIDLINES 7 FILL COLOR 4
display gridlines with fill color 1
print gridlines when using fill color 1
Blank Sheet with Gridlines 11
gridlines won't display 1
missing gridlines 2
Gridlines 1

Back
Top