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

  • Thread starter Thread starter Guest
  • Start date Start date
mj said:
How do I get rid of the gridlines that appear automatically upon opening
worksheet?
Click to expand...

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.
 
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
 
In code can you set a range and only turn-off gridlines from that range?

Set myrng = Activesheet.Range("a5:g20")
 
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.
 
But I like to not show the gridlines and then put borders where I want them.

How do you do this?

Jim
 
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.

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

How do you do this?

Jim
Click to expand...
 
Back
Top