I can't figure out how to remove the light Grey borders that show up on the
worksheet. I can add and remove my own borders, but I can't remove the
borders that show up automatically. I know they don't show up when I print,
but would like to remove them form the worksheet.
Thanks for your help.

This can be found under the 'View' tab in Office 2007, or under the 'View'
menu (I think) in earlier versions. Look for a tickbox labelled 'Gridlines'
untick it and you're there.

HTH

Neil
www.nwarwick.co.uk

"DD" wrote:

I can't figure out how to remove the light Grey borders that show up on the
worksheet. I can add and remove my own borders, but I can't remove the
borders that show up automatically. I know they don't show up when I print,
but would like to remove them form the worksheet.
Thanks for your help.

I do have an old version, I found the gridline box under tools then options.
I'm good to go now. Thanks

"Neil" wrote:

This can be found under the 'View' tab in Office 2007, or under the 'View'
menu (I think) in earlier versions. Look for a tickbox labelled 'Gridlines'
untick it and you're there.

HTH

Neil
www.nwarwick.co.uk

"DD" wrote:

I can't figure out how to remove the light Grey borders that show up on the
worksheet. I can add and remove my own borders, but I can't remove the
borders that show up automatically. I know they don't show up when I print,
but would like to remove them form the worksheet.
Thanks for your help.

ToolsOptionsView in earlier than 2007 version.

Uncheck "Gridlines"

If you wish to remove from just some ranges, format the cells to "white" which
erases the gridlines in just that area.

The default background for cells color is 'no color".


Gord Dibben MS Excel MVP


On Thu, 22 Feb 2007 17:15:03 -0800, DD wrote:

I can't figure out how to remove the light Grey borders that show up on the
worksheet. I can add and remove my own borders, but I can't remove the
borders that show up automatically. I know they don't show up when I print,
but would like to remove them form the worksheet.
Thanks for your help.

thanks for the info, it worked perfectly.

"Gord Dibben" wrote:

ToolsOptionsView in earlier than 2007 version.

Uncheck "Gridlines"

If you wish to remove from just some ranges, format the cells to "white" which
erases the gridlines in just that area.

The default background for cells color is 'no color".


Gord Dibben MS Excel MVP


On Thu, 22 Feb 2007 17:15:03 -0800, DD wrote:

I can't figure out how to remove the light Grey borders that show up on the
worksheet. I can add and remove my own borders, but I can't remove the
borders that show up automatically. I know they don't show up when I print,
but would like to remove them form the worksheet.
Thanks for your help.