![]() |
fill color and gridlines
I like to color certain rows on a spreadsheet to prioritize them for me. But
when I do that, I lose the gridlines (which I need to be able to read across more efficiently). Can I have both? |
Yes you can have both. Format, Cells displays a box with several tabs giving
any varition to lines, text colour, background colour, line colour thickness etc. -- Peter London, UK "jfortier922" wrote: I like to color certain rows on a spreadsheet to prioritize them for me. But when I do that, I lose the gridlines (which I need to be able to read across more efficiently). Can I have both? |
Peter wrote:
Yes you can have both. Format, Cells displays a box with several tabs giving any varition to lines, text colour, background colour, line colour thickness etc. -- Peter London, UK "jfortier922" wrote: I like to color certain rows on a spreadsheet to prioritize them for me. But when I do that, I lose the gridlines (which I need to be able to read across more efficiently). Can I have both? The way I do it: Select the range that is colored. Go to Format/Cells and select Borders. In the "Style" box, select the border just under "None". I know its a border but you can hardly tell the difference (it looks like a gridline) GL Jerry |
All times are GMT +1. The time now is 11:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com