Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resume gridlines
When I use gridlines in printing, the cells with background colour change
lost the gridlines. How can I resume the gridlines? Thanks, Scott |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resume gridlines
Dear Scott,
when you apply colour to a group of cells the gridlines get disappear.Thats what i understand your prob is.For that after filling colours in the group of cells go to borders and click on all borders.All your cells with different colour will show up. "Scott" wrote: When I use gridlines in printing, the cells with background colour change lost the gridlines. How can I resume the gridlines? Thanks, Scott |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resume gridlines
In that situation, you'll have to use borders, rather than gridlines.
-- David Biddulph "Scott" wrote in message ... When I use gridlines in printing, the cells with background colour change lost the gridlines. How can I resume the gridlines? Thanks, Scott |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resume gridlines
"David Biddulph" <groups [at] biddulph.org.uk ¦b¶l¥ó
¤¤¼¶¼g... In that situation, you'll have to use borders, rather than gridlines. -- David Biddulph "Scott" wrote in message ... When I use gridlines in printing, the cells with background colour change lost the gridlines. How can I resume the gridlines? Thanks, Scott Border is different from gridline. When I increase any column or row, I have to format the border again but gridline is automatic. Scott |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resume gridlines
As was pointed out to you.
Coloring the cells wipe out the gridlines. You cannot get them back without setting background to "no color" or "automatic". Gord Dibben MS Excel MVP On Tue, 30 Sep 2008 07:18:50 +0800, "Scott" wrote: Border is different from gridline. When I increase any column or row, I have to format the border again but gridline is automatic. Scott |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resume gridlines
Gord,
Thanks for your pointing out it is shortcoming of Excel since the first version. Is it impossible to address this issue? I have discussed with the users who all have this concern and it seems Microsoft did not receive it so far and never touch this area for improvement. Where can I submit it to Excel development of Microsoft? Regards, Scott "Gord Dibben" <gorddibbATshawDOTca 在郵件 ä¸*撰寫... As was pointed out to you. Coloring the cells wipe out the gridlines. You cannot get them back without setting background to "no color" or "automatic". Gord Dibben MS Excel MVP On Tue, 30 Sep 2008 07:18:50 +0800, "Scott" wrote: Border is different from gridline. When I increase any column or row, I have to format the border again but gridline is automatic. Scott |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resume gridlines
I do not have an address/URL for MS Excel Developers.
Maybe someone else can point you to something. While you're waiting for the Developers to make the upgrade, use this macro whenever you need to add borders to colored cells. Sub add_borders() Dim r As Range For Each r In ActiveSheet.UsedRange If r.Interior.ColorIndex < xlNone Then r.BorderAround , Weight:=xlThin End If Next r End Sub Gord On Wed, 1 Oct 2008 09:23:52 +0800, "Scott" wrote: Gord, Thanks for your pointing out it is shortcoming of Excel since the first version. Is it impossible to address this issue? I have discussed with the users who all have this concern and it seems Microsoft did not receive it so far and never touch this area for improvement. Where can I submit it to Excel development of Microsoft? Regards, Scott "Gord Dibben" <gorddibbATshawDOTca ??? ???... As was pointed out to you. Coloring the cells wipe out the gridlines. You cannot get them back without setting background to "no color" or "automatic". Gord Dibben MS Excel MVP On Tue, 30 Sep 2008 07:18:50 +0800, "Scott" wrote: Border is different from gridline. When I increase any column or row, I have to format the border again but gridline is automatic. Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
On Error Resume Next problem | Excel Discussion (Misc queries) | |||
Theatrical Resume | New Users to Excel | |||
resume.xlw | Excel Discussion (Misc queries) | |||
In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- | New Users to Excel | |||
can I create a new resume? | Excel Discussion (Misc queries) |