#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 119
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gridlines are there, then Custom View, gridlines disappear in xl 2 Winnipeg Michael Excel Discussion (Misc queries) 0 September 15th 08 06:04 PM
gridlines msiz Excel Discussion (Misc queries) 1 June 11th 08 12:08 PM
not all the gridlines print; despite selecting/"gridlines" suewholovesbirds Excel Discussion (Misc queries) 1 October 23rd 06 09:33 PM
Row colors overlay the gridlines...how do I show gridlines? RickToo11 Excel Discussion (Misc queries) 2 September 13th 06 03:46 PM
In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- 4most New Users to Excel 3 July 9th 06 01:45 AM


All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"