| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to remove gridlines from part of a worksheet only | Excel Worksheet Functions | |||
| Gridlines over cell background color. | Excel Discussion (Misc queries) | |||
| Restoring Excel gridlines after removing background shading? | Excel Discussion (Misc queries) | |||
| permanently remove gridlines in regedit for Excel 2003 | Setting up and Configuration of Excel | |||
| Gridlines into excel spreadsheet after changing background color | Excel Worksheet Functions | |||
Hybrid Mode
