Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
GRIDLINES
I have a document with groups of rows that alternate color (green and
yellow). I want to see light gridlines in these sections (NOT BORDERS), and have tried Tools/Options/Gridlines, but this only toggles the gridlines on and off in the blank, white columns to the right of the section with color and data. I've also tried Page Setup/Sheet/Gridlines, but no luck there either. -- William |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
GRIDLINES
If you set the interior background color of a cell, the gridlines do not
"bleed thru". This is even true for the white background. That is why most people set the borders if they color the interior of cells and want the gridline effect. -- Gary''s Student - gsnu200860 "William" wrote: I have a document with groups of rows that alternate color (green and yellow). I want to see light gridlines in these sections (NOT BORDERS), and have tried Tools/Options/Gridlines, but this only toggles the gridlines on and off in the blank, white columns to the right of the section with color and data. I've also tried Page Setup/Sheet/Gridlines, but no luck there either. -- William |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
GRIDLINES
What exactly are you calling gridlines (not borders)? The usual convention is
that gridlines is having each cell have a border, as opposed to a group of cells having a single border. If this is the case, it depends on how your colors are being generated. If manually, simply format cells - borders, and select lines that go in between the cells. If conidtionally formatted, change the format setting to include a cell border. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "William" wrote: I have a document with groups of rows that alternate color (green and yellow). I want to see light gridlines in these sections (NOT BORDERS), and have tried Tools/Options/Gridlines, but this only toggles the gridlines on and off in the blank, white columns to the right of the section with color and data. I've also tried Page Setup/Sheet/Gridlines, but no luck there either. -- William |
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) | |||
gridlines | 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 |