Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - cell borders not visible when cells colored
In Excel 2007, when cells are colored, the cell borders are not visible. Is
it possible to enable the borders when cells are colored? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - cell borders not visible when cells colored
I have always eliminated the gridlines from spreadsheets and, so, hadn't
noticed this behavior in 2007. After experimenting with it a little though, it appears shading ddoes overwrite the gridlines, so you will need to actually format the cells with borders to make them appear *like* gridlines. "JLW1" wrote: In Excel 2007, when cells are colored, the cell borders are not visible. Is it possible to enable the borders when cells are colored? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - cell borders not visible when cells colored
Shoot! That's what we were hoping wasn't the case. Thanks for your time!
"Duke Carey" wrote: I have always eliminated the gridlines from spreadsheets and, so, hadn't noticed this behavior in 2007. After experimenting with it a little though, it appears shading ddoes overwrite the gridlines, so you will need to actually format the cells with borders to make them appear *like* gridlines. "JLW1" wrote: In Excel 2007, when cells are colored, the cell borders are not visible. Is it possible to enable the borders when cells are colored? |
#4
|
|||
|
|||
Select the cells (all or just a few) that you would like to color the background. Go to Format Cells. Under Patterns select the color you would like for the cell backgrounds. Under border select first the colors of the gridlines you would like, Then select the line style (dashed, heavy, double, etc). Then press the Outline and the Inside buttons. This will give you colored cells with gridlines
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Workbook Not Visible | Excel Discussion (Misc queries) | |||
Transparent Cell Borders For Formula Cells? | Excel Discussion (Misc queries) | |||
borders in excel not printing in Excel 2007 | Excel Discussion (Misc queries) | |||
charts are not visible in excel 2007 | Charts and Charting in Excel | |||
I cannot edit cell borders or text in certain cells. | Excel Worksheet Functions |