Gridlines

[Judith Venning]

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?

 

[Gord Dibben]

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

 

[Guest]

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

 

[David McRitchie]

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

 

[Dave Peterson]

Here's a link to a previous discussion for the gridlines stuff:
http://groups.google.com/[email protected]

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.