Table Formatting

[jalopy05]

Amateur question:

How do I get rid of the standard, border-free, grid lines in my spreadsheet even though they don't appear when I print? Thanks.

 

[Richard Schollar]

xl2003 or below:

Tools>options>View tab and uncheck Gridlines

xl2007:

View Ribbon and uncheck Gridlines in the Show/Hide section

 

[jalopy05]

is there a way to do this for specific tables/charts within a spreadsheet instead of removing the gridlines from the whole spreadsheet?

 

[Richard Schollar]

It only applies it to the currently activesheet when you uncheck the settings (or at least that's how it seems to me) - is it doing something different for you?

 

[jalopy05]

Ok, that's right. Thanks for the help! I appreciate it.