When I format cells (fill) w/ color, my gridlines disappear.
C Chip Pearson Oct 19, 2006 #2 That is the way Excel works. The fill color overlays the gridlines. Add borders to the cells to make your own "gridlines"
That is the way Excel works. The fill color overlays the gridlines. Add borders to the cells to make your own "gridlines"
S Sherry Oct 19, 2006 #3 I thought there might be another way. I tried that but it's cumbersome with a large spreadsheet. Thanks!
I thought there might be another way. I tried that but it's cumbersome with a large spreadsheet. Thanks!
D Dave Peterson Oct 19, 2006 #4 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 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.