Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JanetGU
 
Posts: n/a
Default How do I get the gridlines to print OVER colored cells?

Some rows in my spreadsheet are colored. When I try to print it, the color
is hiding the gridlines. I want the gridlines to show.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie
 
Posts: n/a
Default How do I get the gridlines to print OVER colored cells?

Hi Janet,
You will have to use borders instead, because the cells with
interior color or borders will mask gridlines.
http://www.mvps.org/dmcritchie/excel/gridline.htm

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JanetGU" wrote in message ...
Some rows in my spreadsheet are colored. When I try to print it, the color
is hiding the gridlines. I want the gridlines to show.



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
How do I PRINT gridlines? BigRed Setting up and Configuration of Excel 8 December 11th 08 04:09 PM
How can I print gridlines with Excel 2000 Janisdee Excel Discussion (Misc queries) 1 March 13th 06 06:24 PM
I just want to print an excel sheet showing gridlines with no text jiggityjohnson New Users to Excel 4 January 16th 06 05:39 PM
print specific cells Wendy Excel Discussion (Misc queries) 1 February 10th 05 06:52 PM
Excel - formula to calculate colored fill cells within a range wi. MA Excel Worksheet Functions 1 January 7th 05 04:06 PM


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