B
BK
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??
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??