ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   fill color and gridlines (https://www.excelbanter.com/excel-discussion-misc-queries/45899-fill-color-gridlines.html)

jfortier922

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?

Peter

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?


[email protected]

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