How to show/print guidelines over color rows & columns?

A

Amiris221

when I add color ro a row or/and columns the guidlines disap4ear - How do I
ge them to show up over the color? On the spreadsheet that I haven't
colored, they are fine,
 
A

Amiris221

Sorry Martin, but even when I take the color off and go back to white the
gridlines NRVER return.
 
S

Sandy Mann

If by:
Sorry Martin, but even when I take the color off and go back to white
Click to expand...

you mean that you selected White from the Pattern palet then it will still
cover the borders. Try selecting "No Color" instead.

If you want to colour the cells and still have edges to then then use
Borders:

Format > Cells > Border

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
D

David Biddulph

There is a difference between making the background white and making it "no
fill". A white (or any coloured) background pattern will indeed hide your
gridlines.

You haven't quoted the message to which you intended to reply, and you seem
to have replied to your own original message, not to anyone else's
follow-up, so I don't know what they suggested, but have you tried Format/
Cells/ Borders ... ?
 
M

Martin Fishlock

If you use the fill color then the gridlines are hidden (even with white).

Use No fill to get the gridlines back or use borders to set the gridlines on
the areas where you want lines (but these print out as well).
 
Top