Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

making gridlines visible

Posted by sean on February 16, 2002 5:49 AM
hi there,

I have several charts created. I'm importing them into WORD. Because I want to put many on one page, I remove the chart area border and set the fill to None, so I can move them very close to one another in WORD. this works very well and I like it.....now to my question...

In excel, when I take out the chart fill and border, I can see gridlines behind graph and this makes the graphs harder to see clear while working on them...so I change the cell fill to another colour....this works good but the grdlines are not visible when I fill the spreadsheet celss with colour.

Is there any way to make the gridlines semi-visible using a different colour for the background? Sorry for the long explanation.

thanks


Re: making gridlines visible

Posted by Dreamboat on February 16, 2002 4:54 PM
Choose the cells you want gridlines on and hit Format-Cells-Borders. Choose a light-gray border.



This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.