| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gridlines disappear when using "Fill"
When I format cells (fill) w/ color, my gridlines disappear.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines disappear when using "Fill"
That is the way Excel works. The fill color overlays the gridlines. Add
borders to the cells to make your own "gridlines" "Sherry" wrote in message ... When I format cells (fill) w/ color, my gridlines disappear. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines disappear when using "Fill"
I thought there might be another way. I tried that but it's cumbersome with
a large spreadsheet. Thanks! "Chip Pearson" wrote: That is the way Excel works. The fill color overlays the gridlines. Add borders to the cells to make your own "gridlines" "Sherry" wrote in message ... When I format cells (fill) w/ color, my gridlines disappear. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines disappear when using "Fill"
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. Sherry wrote: I thought there might be another way. I tried that but it's cumbersome with a large spreadsheet. Thanks! "Chip Pearson" wrote: That is the way Excel works. The fill color overlays the gridlines. Add borders to the cells to make your own "gridlines" "Sherry" wrote in message ... When I format cells (fill) w/ color, my gridlines disappear. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do gridlines disappear from view when highlighted | Excel Worksheet Functions | |||
| Gridlines in excel | Excel Discussion (Misc queries) | |||
| How do I add gridlines on a graph? | Charts and Charting in Excel | |||
| Excel gridlines disappear when color is added | Excel Discussion (Misc queries) | |||
| How do you add gridlines? | Excel Worksheet Functions | |||
Linear Mode
