Excel background gridlines on worksheet-how do I remove from view

[Guest]

How do I get rid of the gridlines that appear automatically upon opening
worksheet?

 

[Guest]

Tools>Options>View>uncheck Gridlines
or
View>Toolbars>Forms>click on Toggle Grid

tim

 

[Harlan Grove]

How do I get rid of the gridlines that appear automatically upon opening
worksheet?

If you never want to see gridlines in new workbooks you create, and you're
willing to risk editing the Windows Registry, use regedit to add 4000 hex to
the value of Options3 in the subkey

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

The 11.0 bit is specific to Excel 2003. Use 10.0 for Excel 2002, 9.0 for
Excel 2000, 8.0 for Excel 97. Dunno whether this works for Excel 2007.

 

[Guest]

Hi,
Do the following:

1. On the Tools menu, click Options. The Options dialog box is displayed.
2. Click the View Tab.
3. Under the Windows options section, clear the Gridlines Check box.
4. Click Ok to save the settings and return to the active worksheet.

Challa Prabhu

 

[Dave Peterson]

Just to add a few more ways:
http://groups.google.com/group/microsoft.public.excel.misc/msg/3d4905543470a0a4

 

[Guest]

In code can you set a range and only turn-off gridlines from that range?

Set myrng = Activesheet.Range("a5:g20")

 

[Dave Peterson]

Gridlines refer to the window--not a range.

You could give that range a fill color to hide the gridlines. But I like to not
show the gridlines and then put borders where I want them.

 

[Guest]

But I like to not show the gridlines and then put borders where I want them.

How do you do this?

Jim

 

[Dave Peterson]

Tools|Options|view tab|uncheck gridlines.

Select the cells you want to have a border
format|cells|border tab
and format to your heart's content.

Or use the border icons on the formatting toolbar.

But I like to not show the gridlines and then put borders where I want them.

How do you do this?

Jim