Gridlines

I loaded Excel 2000 and found no gridlines showing on
sheets. I have upgraded it to XP, but still no gridlines.
I can only putthem in per sheet via Tools Options. How
can I get them back by default?

Judith

Assuming that the workbook with no sheets gridlines is the default workbook
that comes up when you open Excel or select File>New Workbook.............

I would guess that you have a BOOK.XLT template in your XLSTART folder with
these "gridlines off" settings. This template is the basis for all new
workbooks(Book1.xls).

Do a Start>Find>Files and Folders and look for BOOK.XLT. If found in your
XLSTART folder, move it out and see what happens. Also look for SHEET.XLT in
the same folder. This would be the default Insert>New Worksheet.

Gord Dibben XL2002



On Sun, 16 Nov 2003 07:00:37 -0800, "Judith Venning"
<jvenning@worldonline.co.uk> wrote:

>I loaded Excel 2000 and found no gridlines showing on
>sheets. I have upgraded it to XP, but still no gridlines.
>I can only putthem in per sheet via Tools Options. How
>can I get them back by default?

Thanks for your help. I found XLSTART and it was empty,
so I saved BOOK.XLT AND SHEET.XLT and moved them to it.
They did not go there automatically as templates. I set
the grids to black as auto doesn't seem to work. This is
fine now for new workbooks, but old ones still import with
no lines, even though they did have them before my
computer crashed.!
-----Original Message-----
>Judith
>
>Assuming that the workbook with no sheets gridlines is
the default workbook
>that comes up when you open Excel or select File>New
Workbook.............
>
>I would guess that you have a BOOK.XLT template in your
XLSTART folder with
>these "gridlines off" settings. This template is the
basis for all new
>workbooks(Book1.xls).
>
>Do a Start>Find>Files and Folders and look for BOOK.XLT.
If found in your
>XLSTART folder, move it out and see what happens. Also
look for SHEET.XLT in
>the same folder. This would be the default Insert>New
Worksheet.
>
>Gord Dibben XL2002
>
>
>
>On Sun, 16 Nov 2003 07:00:37 -0800, "Judith Venning"
><jvenning@worldonline.co.uk> wrote:
>
>>I loaded Excel 2000 and found no gridlines showing on
>>sheets. I have upgraded it to XP, but still no
gridlines.
>>I can only putthem in per sheet via Tools Options. How
>>can I get them back by default?
>
>.
>

Hi anonymous poster,
Templates only affect options in new workbooks (book.xlt) and
in new worksheets added to existing workbooks (sheet.xlt).
Whatever you you previously had remains unchanged.

You should be including your name (first and last) in your posting,
anonymous posting allows you to not reveal your email address
if you aren't going to take measures to deal with spam. You will
find that most posters here do take measures to deal with spam
and do post their names and email addresses, much more friendly.
You can obtain a hotmail account set the spam blocking high to eliminate
almost all spam. Avoid using the email name but for hotmail.com as
your normal email address. .

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

<anonymous@discussions.microsoft.com> wrote in message news:095f01c3b03e$8651baf0$3101280a@phx.gbl...
> Thanks for your help. I found XLSTART and it was empty,
> so I saved BOOK.XLT AND SHEET.XLT and moved them to it.
> They did not go there automatically as templates. I set
> the grids to black as auto doesn't seem to work. This is
> fine now for new workbooks, but old ones still import with
> no lines, even though they did have them before my
> computer crashed.!
> -----Original Message-----
> >Judith
> >
> >Assuming that the workbook with no sheets gridlines is
> the default workbook
> >that comes up when you open Excel or select File>New
> Workbook.............
> >
> >I would guess that you have a BOOK.XLT template in your
> XLSTART folder with
> >these "gridlines off" settings. This template is the
> basis for all new
> >workbooks(Book1.xls).
> >
> >Do a Start>Find>Files and Folders and look for BOOK.XLT.
> If found in your
> >XLSTART folder, move it out and see what happens. Also
> look for SHEET.XLT in
> >the same folder. This would be the default Insert>New
> Worksheet.
> >
> >Gord Dibben XL2002
> >
> >
> >
> >On Sun, 16 Nov 2003 07:00:37 -0800, "Judith Venning"
> ><jvenning@worldonline.co.uk> wrote:
> >
> >>I loaded Excel 2000 and found no gridlines showing on
> >>sheets. I have upgraded it to XP, but still no
> gridlines.
> >>I can only putthem in per sheet via Tools Options. How
> >>can I get them back by default?
> >
> >.
> >

Here's a link to a previous discussion for the gridlines stuff:
http://groups.google.com/groups?sel...16324%40msn.com

This was to remove the gridlines, but maybe you could do the opposite of these
suggestions.

I'm not sure what you're importing, but you may want to use the icon on the
custom toolbar to just to make toggling gridlines a mouse click away.

anonymous@discussions.microsoft.com wrote:
>
> Thanks for your help. I found XLSTART and it was empty,
> so I saved BOOK.XLT AND SHEET.XLT and moved them to it.
> They did not go there automatically as templates. I set
> the grids to black as auto doesn't seem to work. This is
> fine now for new workbooks, but old ones still import with
> no lines, even though they did have them before my
> computer crashed.!
> -----Original Message-----
> >Judith
> >
> >Assuming that the workbook with no sheets gridlines is
> the default workbook
> >that comes up when you open Excel or select File>New
> Workbook.............
> >
> >I would guess that you have a BOOK.XLT template in your
> XLSTART folder with
> >these "gridlines off" settings. This template is the
> basis for all new
> >workbooks(Book1.xls).
> >
> >Do a Start>Find>Files and Folders and look for BOOK.XLT.
> If found in your
> >XLSTART folder, move it out and see what happens. Also
> look for SHEET.XLT in
> >the same folder. This would be the default Insert>New
> Worksheet.
> >
> >Gord Dibben XL2002
> >
> >
> >
> >On Sun, 16 Nov 2003 07:00:37 -0800, "Judith Venning"
> ><jvenning@worldonline.co.uk> wrote:
> >
> >>I loaded Excel 2000 and found no gridlines showing on
> >>sheets. I have upgraded it to XP, but still no
> gridlines.
> >>I can only putthem in per sheet via Tools Options. How
> >>can I get them back by default?
> >
> >.
> >

--

Dave Peterson
ec35720@msn.com