| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gridlines
When I make the background to my worksheet a different color, I cant get the
gridlines to appear. I go through Excel options, choose Advanced and change the color of the gridlines to black, yet no gridlines appear. Where might I be going wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines
Hi Brian,
The Gridline Option on the Advanced tab only changes the colour when there is no background colour in the cells. If you want the gridlines to show through a background colour you wil need to highlight the area and add borders either using Format + Cells or the Borders icon next to Fill Colour. -- Hope this helps Judith "Brian86" wrote: When I make the background to my worksheet a different color, I cant get the gridlines to appear. I go through Excel options, choose Advanced and change the color of the gridlines to black, yet no gridlines appear. Where might I be going wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Gridlines are there, then Custom View, gridlines disappear in xl 2 | Excel Discussion (Misc queries) | |||
| not all the gridlines print; despite selecting/"gridlines" | Excel Discussion (Misc queries) | |||
| Row colors overlay the gridlines...how do I show gridlines? | Excel Discussion (Misc queries) | |||
| In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- | New Users to Excel | |||
| gridlines | Charts and Charting in Excel | |||
Linear Mode
