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

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

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

ToolsOptionsViewuncheck Gridlines
or
ViewToolbarsFormsclick on Toggle Grid

tim

"mj" wrote:

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

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

"mj" wrote...
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\E xcel\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.

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

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

"mj" wrote:

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

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

Just to add a few more ways:
http://groups.google.com/group/micro...4905543470a0a4

mj wrote:

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

--

Dave Peterson

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

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

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


"Dave Peterson" wrote:

Just to add a few more ways:
http://groups.google.com/group/micro...4905543470a0a4

mj wrote:

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

--

Dave Peterson

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

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.



Jim May wrote:

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

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

"Dave Peterson" wrote:

Just to add a few more ways:
http://groups.google.com/group/micro...4905543470a0a4

mj wrote:

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

--

Dave Peterson


--

Dave Peterson

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

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

How do you do this?

Jim


"Dave Peterson" wrote:

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.



Jim May wrote:

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

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

"Dave Peterson" wrote:

Just to add a few more ways:
http://groups.google.com/group/micro...4905543470a0a4

mj wrote:

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

--

Dave Peterson


--

Dave Peterson

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

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 May wrote:

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

How do you do this?

Jim

"Dave Peterson" wrote:

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.



Jim May wrote:

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

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

"Dave Peterson" wrote:

Just to add a few more ways:
http://groups.google.com/group/micro...4905543470a0a4

mj wrote:

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

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson