Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jfortier922
 
Posts: n/a
Default 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?
  #2   Report Post  
Peter
 
Posts: n/a
Default

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?

  #3   Report Post  
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"