ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   GRIDLINES (https://www.excelbanter.com/excel-discussion-misc-queries/239447-gridlines.html)

William

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

Gary''s Student

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


Luke M

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



All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com