Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 47
Default Shaded Cells and gridlines

Is this problem solvable without using borders?

When you colour a cell you do not have the option to still leave the
gridlines visible, essentially the gridline becomes the colour of the
cell fill.

Other than adding borders, which can be a bit off a faff, I have not
been able to find any way of leaving the gridlines visible (and
printable if the page setup is to print gridlines) – any ideas?

Thanks,
Darren
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Shaded Cells and gridlines

Using borders is your only option.

--
Biff
Microsoft Excel MVP


"Darren Hill" wrote in message
et...
Is this problem solvable without using borders?

When you colour a cell you do not have the option to still leave the
gridlines visible, essentially the gridline becomes the colour of the cell
fill.

Other than adding borders, which can be a bit off a faff, I have not been
able to find any way of leaving the gridlines visible (and printable if
the page setup is to print gridlines) – any ideas?

Thanks,
Darren



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
Shaded cells won't print shaded Linda C Excel Worksheet Functions 4 April 3rd 23 06:59 PM
How can I see Excel gridlines when cells are shaded? donnafreem Excel Discussion (Misc queries) 1 April 10th 07 05:50 PM
How do I get gridlines in shaded cells? Joemerald Excel Discussion (Misc queries) 1 February 13th 07 06:04 PM
Not printing shaded cells... Randy L Excel Discussion (Misc queries) 4 November 10th 06 04:56 PM
Delete shaded cells Patience Excel Discussion (Misc queries) 1 February 2nd 05 04:43 PM


All times are GMT +1. The time now is 08:32 PM.

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"