Excel gridlines not behaving

G

Guest

I created a form in Excel 2003 and changed the borders of unnessessary cells
to white so the user isn't distracted. I've done this many times with no
problem. This time though for some reason any borders that have been set to
white, print out as black lines.
 
A

Anne Troy

1. Borders are formatted by the user.
2. Gridlines are formatted by Excel. You can choose to print gridlines under
File-->Page setup, Sheet tab.

Given those truths, it sounds to me like you have turned ON printing of
gridlines. It also seems that you should remove all borders (to get rid of
the white ones), put borders ONLY around the cells you want them, and then
turn off viewing of gridlines so you don't see them (hence, the borders look
"white").

By using white borders or white cell fill to hide gridlines, you can
unnecessarily bloat the workbook.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top