| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gridlines
There are never any gridlines when I open Excel. I have gridlines checked in
everthing I can find but still they are not there. What else can I do? -- Carol |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines
Check to see if you have a book.xlt template file in your XLStart folder.
Maybe it's set up not to show gridlines. If you do, you can open it (as a template), change the gridlines to show and resave it. Carol wrote: There are never any gridlines when I open Excel. I have gridlines checked in everthing I can find but still they are not there. What else can I do? -- Carol -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines
Where do I find that at? I'm new to this.
-- Carol "Dave Peterson" wrote: Check to see if you have a book.xlt template file in your XLStart folder. Maybe it's set up not to show gridlines. If you do, you can open it (as a template), change the gridlines to show and resave it. Carol wrote: There are never any gridlines when I open Excel. I have gridlines checked in everthing I can find but still they are not there. What else can I do? -- Carol -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines
Use windows search to look for either book.xlt or xlstart (or both!).
For me (winXP home and xl2003), it's he C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART And depending on your upgrade path, you may have multiple locations. Carol wrote: Where do I find that at? I'm new to this. -- Carol "Dave Peterson" wrote: Check to see if you have a book.xlt template file in your XLStart folder. Maybe it's set up not to show gridlines. If you do, you can open it (as a template), change the gridlines to show and resave it. Carol wrote: There are never any gridlines when I open Excel. I have gridlines checked in everthing I can find but still they are not there. What else can I do? -- Carol -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines
I have Vista (another headache!) so can't find any of this stuff.
-- Carol "Dave Peterson" wrote: Use windows search to look for either book.xlt or xlstart (or both!). For me (winXP home and xl2003), it's he C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART And depending on your upgrade path, you may have multiple locations. Carol wrote: Where do I find that at? I'm new to this. -- Carol "Dave Peterson" wrote: Check to see if you have a book.xlt template file in your XLStart folder. Maybe it's set up not to show gridlines. If you do, you can open it (as a template), change the gridlines to show and resave it. Carol wrote: There are never any gridlines when I open Excel. I have gridlines checked in everthing I can find but still they are not there. What else can I do? -- Carol -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines
Open excel
Hit alt-f11 to see the VBE (where macros live) hit ctrl-g to see the immediate window type this ?application.startuppath Make a note of the location. Carol wrote: I have Vista (another headache!) so can't find any of this stuff. -- Carol "Dave Peterson" wrote: Use windows search to look for either book.xlt or xlstart (or both!). For me (winXP home and xl2003), it's he C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART And depending on your upgrade path, you may have multiple locations. Carol wrote: Where do I find that at? I'm new to this. -- Carol "Dave Peterson" wrote: Check to see if you have a book.xlt template file in your XLStart folder. Maybe it's set up not to show gridlines. If you do, you can open it (as a template), change the gridlines to show and resave it. Carol wrote: There are never any gridlines when I open Excel. I have gridlines checked in everthing I can find but still they are not there. What else can I do? -- Carol -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines
ps. You should have at least one XLStart folder, but you may not have any
templates named book.xlt within that folder. Dave Peterson wrote: Open excel Hit alt-f11 to see the VBE (where macros live) hit ctrl-g to see the immediate window type this ?application.startuppath Make a note of the location. Carol wrote: I have Vista (another headache!) so can't find any of this stuff. -- Carol "Dave Peterson" wrote: Use windows search to look for either book.xlt or xlstart (or both!). For me (winXP home and xl2003), it's he C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART And depending on your upgrade path, you may have multiple locations. Carol wrote: Where do I find that at? I'm new to this. -- Carol "Dave Peterson" wrote: Check to see if you have a book.xlt template file in your XLStart folder. Maybe it's set up not to show gridlines. If you do, you can open it (as a template), change the gridlines to show and resave it. Carol wrote: There are never any gridlines when I open Excel. I have gridlines checked in everthing I can find but still they are not there. What else can I do? -- Carol -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Gridlines are there, then Custom View, gridlines disappear in xl 2 | Excel Discussion (Misc queries) | |||
| not all the gridlines print; despite selecting/"gridlines" | Excel Discussion (Misc queries) | |||
| Row colors overlay the gridlines...how do I show gridlines? | Excel Discussion (Misc queries) | |||
| In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- | New Users to Excel | |||
| Gridlines | Excel Discussion (Misc queries) | |||
Linear Mode
