Adding new worksheets

[RonD]

Every time I add a new worksheet, it defaults to a blue
filled background. How can I revert back to a plain blank
sheet?

Thanks.
RonD.

 

[Peo Sjoblom]

You must have a sheet template with blue back ground, find all *.xlt files
and check them,
change the one with blue background
Sheet.xlt

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Guest]

Thanks. I have searched my computer and found no *.xlt
files, except some default templates like Balance
Sheet.xlt, ExpenseStatement.xlt, etc. There is no
sheet.xlt anywhere that I can find.

BTW... I can open other xls files on my computer and add a
new sheet in them without getting a background color. The
problem is ONLY when I open this one specific xls file.

I have Excel 2002 (10.6501.6626) SP3 running on Windows XP
Pro, V5.1.2600 SP1 Bld 2600.

Any other ideas?

Thanks.

 

[David McRitchie]

and yet you can change the color back to default white ?
So you can see gridlines without resorting to having to use borders?

Check your colors to the default
tools, options, colors (tab)
and compare to
http://www.mvps.org/dmcritchie/excel/colors.htm#colorindex

If you just want to reset back to default (I would check first so you
know one way or the other) there is a [Reset] button on the
colors (tab).

 

[RonD]

Yes, I can select the whole new sheet and "no fill" it so
it becomes a default blank white with default gray grid
lines.

I reset my color palette, as you suggested. But I still
have my original problem: New sheets are added with the
gray background color that is the same as the normal grid
line color, so the grid lines don't show up.

Thanks for all the good ideas. Any more?

RonD

-----Original Message-----
and yet you can change the color back to default white ?
So you can see gridlines without resorting to having to use borders?

Check your colors to the default
tools, options, colors (tab)
and compare to
http://www.mvps.org/dmcritchie/excel/colors.htm#colorindex

If you just want to reset back to default (I would check first so you
know one way or the other) there is a [Reset] button on the
colors (tab).
---
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

Thanks. I have searched my computer and found no *.xlt
files, except some default templates like Balance
Sheet.xlt, ExpenseStatement.xlt, etc. There is no
sheet.xlt anywhere that I can find.

BTW... I can open other xls files on my computer and add a
new sheet in them without getting a background color. The
problem is ONLY when I open this one specific xls file.

I have Excel 2002 (10.6501.6626) SP3 running on Windows XP
Pro, V5.1.2600 SP1 Bld 2600.

Any other ideas?

Thanks.

.

 

[RonD]

Well, no one was able to tell me how to fix my problem, so
I kept poking around all the options until I found the
culprit.

In case anyone else is interested...

My "Normal" style had been accidently changed to include
the gray shading. To fix it, I went into Format+Style,
selected style name "Normal", then Modify+Patterns+NoColor.

Now I can add new sheets without any shading.

-----Original Message-----
Yes, I can select the whole new sheet and "no fill" it so
it becomes a default blank white with default gray grid
lines.

I reset my color palette, as you suggested. But I still
have my original problem: New sheets are added with the
gray background color that is the same as the normal grid
line color, so the grid lines don't show up.

Thanks for all the good ideas. Any more?

RonD

-----Original Message-----
and yet you can change the color back to default white ?
So you can see gridlines without resorting to having to use borders?

Check your colors to the default
tools, options, colors (tab)
and compare to
http://www.mvps.org/dmcritchie/excel/colors.htm#colorindex

If you just want to reset back to default (I would

check
first so you

know one way or the other) there is a [Reset] button

on

the
colors (tab).
---
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

Thanks. I have searched my computer and found no *.xlt
files, except some default templates like Balance
Sheet.xlt, ExpenseStatement.xlt, etc. There is no
sheet.xlt anywhere that I can find.

BTW... I can open other xls files on my computer and add a
new sheet in them without getting a background color. The
problem is ONLY when I open this one specific xls file.

I have Excel 2002 (10.6501.6626) SP3 running on

Windows

XP


.

.

 

[David McRitchie]

Hi Ron,
THANKS, so when I went to see where I could squirrel this newly
acquired information, I see that it fooled me three years ago as well.

Style: THINGS THAT LOOK LIKE TEMPLATES
Style: THINGS THAT LOOK LIKE TEMPLATES
Style: THINGS THAT LOOK LIKE TEMPLATES

Anyway, Maybe I'll remember that NOW. I added after the other one
that involved a style courtesy of Hank Scorpio.

Things that act like templates (#style)
Templates, book.xlt, sheet.xlt, and beyond
http://www.mvps.org/dmcritchie/excel/template.htm#style

So much for color palette, template, mysterious color [colour],
colored cells