No grid lines with color



Using Excel 2003. I click on "file | page setup | sheet | gridlines" so
that the grids will show when printed.

Once I select certain rows or cells and fill them with color, those grid
lines don't show up any longer. I know I can choose to set "all borders" so
that grid lines will show, but then I run into other issues. Newly added
rows have to have "all borders" set again. If I select the entire worksheet
and set "all borders" then I know only filled in rows will show on the
printed copy. But if I go back and delete that row later, then I still have
extra bordered rows showing up on my print out.

Is there any way to use the "file | page setup | sheet | gridlines" with
color coded rows and cells??




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