Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to show/print guidelines over color rows & columns?
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to show/print guidelines over color rows & columns?
Try setting the colo(u)r of the gridlines to a contrasting colo(u)r.
-- Hope this helps Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand Please do not forget to rate this reply. "Amiris221" wrote: 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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to show/print guidelines over color rows & columns?
Sorry Martin, but even when I take the color off and go back to white the
gridlines NRVER return. "Amiris221" wrote: when I add color to a row or/and columns the gridlines disap4ear - How do I ge them to show up over the color? On the spreadsheet that I haven't colored, they are fine, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to show/print guidelines over color rows & columns?
If by:
Sorry Martin, but even when I take the color off and go back to white 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 Replace @mailinator.com with @tiscali.co.uk "Amiris221" wrote in message ... Sorry Martin, but even when I take the color off and go back to white the gridlines NRVER return. "Amiris221" wrote: when I add color to a row or/and columns the gridlines disap4ear - How do I ge them to show up over the color? On the spreadsheet that I haven't colored, they are fine, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to show/print guidelines over color rows & columns?
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 ... ? -- David Biddulph "Amiris221" wrote in message ... Sorry Martin, but even when I take the color off and go back to white the gridlines NRVER return. "Amiris221" wrote: when I add color to a row or/and columns the gridlines disap4ear - How do I ge them to show up over the color? On the spreadsheet that I haven't colored, they are fine, |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to show/print guidelines over color rows & columns?
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). -- Hope this helps Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand Please do not forget to rate this reply. "Amiris221" wrote: Sorry Martin, but even when I take the color off and go back to white the gridlines NRVER return. "Amiris221" wrote: when I add color to a row or/and columns the gridlines disap4ear - How do I ge them to show up over the color? On the spreadsheet that I haven't colored, they are fine, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show a solid color cell fill in excel, but not print it ? | Excel Discussion (Misc queries) | |||
show rows on screen, but not print them | Excel Discussion (Misc queries) | |||
cell fill color will only show up in print preview | Excel Discussion (Misc queries) | |||
XL print preview should show grayscale if chosen on color printer | Excel Discussion (Misc queries) | |||
How do you print an Excel worksheet to show the rows and columns? | New Users to Excel |