Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
nelson1344
 
Posts: n/a
Default Excel gridlines disappear when color is added

When adding color to rows or columns in excel worksheets, the gridlines
disappear. How can I get the gridlines to print, even if the worksheets has
colored rows or columns?
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Nelson,

Cell fill color, even white, paints right over the gridlines. You can use
borders (Format - Cells - Borders).
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"nelson1344" wrote in message
...
When adding color to rows or columns in excel worksheets, the gridlines
disappear. How can I get the gridlines to print, even if the worksheets
has
colored rows or columns?



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Add borders to your worksheet
format|cells|borders tab
And don't print those gridlines.

(fill colors kill those gridlines--as you've seen)

nelson1344 wrote:

When adding color to rows or columns in excel worksheets, the gridlines
disappear. How can I get the gridlines to print, even if the worksheets has
colored rows or columns?


--

Dave Peterson
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
In excel the gridlines wont print on spreadsheets? debby Excel Discussion (Misc queries) 2 March 1st 05 05:35 PM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 05:47 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 05:45 AM
Excel user desires to learn ABC of Access Hari Excel Discussion (Misc queries) 1 December 3rd 04 02:32 AM
OPENING TWO DIFFERENT EXCEL PROGRAMS EXCEL SPREADSHEETS Excel Discussion (Misc queries) 3 December 2nd 04 11:14 PM


All times are GMT +1. The time now is 11:46 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"