Resume gridlines

S

Scott

When I use gridlines in printing, the cells with background colour change
lost the gridlines. How can I resume the gridlines?

Thanks,

Scott
 
B

Bharat.

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.
 
S

Scott

David Biddulph said:
In that situation, you'll have to use borders, rather than gridlines.

Border is different from gridline. When I increase any column or row, I
have to format the border again but gridline is automatic.

Scott
 
G

Gord Dibben

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
 
S

Scott

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank Sheet with Gridlines 11
GRIDLINES 7 FILL COLOR 4
missing gridlines 2
Gridlines in Office 2007 1
Gridlines 1
Gridlines not shown in certain cells 2
display gridlines with fill color 1
Gridlines 1

Top