W
worksheet tabs
How do I change the font/fill color of Excel 2000 worksheet tabs?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Harald Staff
You can't -they follow Windows. (So change some Windows setting and they'll
all change, I suspect that's not what you want). Upgrade to XP or 2003 for
colored tabs.
HTH. Best wishes Harald
all change, I suspect that's not what you want). Upgrade to XP or 2003 for
colored tabs.
HTH. Best wishes Harald
F
Frank Kabel
Hi
not possible. Excel 2002 introduced this feature
not possible. Excel 2002 introduced this feature
M
Myrna Larson
Assuming you mean different colors for different tabs, I believe that feature
was added in XL-XP, i.e. 2002. If you right-click on a tab and the feature is
available, it'll be on the menu. If you don't see it, you don't have it.
On Tue, 12 Oct 2004 12:41:06 -0700, "worksheet tabs" <worksheet
was added in XL-XP, i.e. 2002. If you right-click on a tab and the feature is
available, it'll be on the menu. If you don't see it, you don't have it.
On Tue, 12 Oct 2004 12:41:06 -0700, "worksheet tabs" <worksheet
T
Terry
I run win98se OS with MS-Office XP Pro installed, and works a
treat...including a TAB color option.
Terry
treat...including a TAB color option.
Terry
D
David McRitchie
As the others have indicated to BOTH of your postings, the feature
was added in Excel 2002. Please post only once and wait for your answers
to roll in, which they actually did before you posted the second time. Half an
hour is very short time to have waited for someone else to be answering your
question. A day or two would be more appropriated and work on something else.
However, I can hardly see moving up to Excel 2002 for something minor
like worksheet tab color, which really isn't going to gain you much of anything.
There are better things that you can do with the worksheet tabs such as
sort the worksheet tabs see SortALLsheets macro in
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets
and comment about color sheet tabs in
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs
You can rename some of your worksheetnames so that sorting will keep
groups of sheets together. i.e. k.FunctKeys, k.ShortCutKeys -
was added in Excel 2002. Please post only once and wait for your answers
to roll in, which they actually did before you posted the second time. Half an
hour is very short time to have waited for someone else to be answering your
question. A day or two would be more appropriated and work on something else.
However, I can hardly see moving up to Excel 2002 for something minor
like worksheet tab color, which really isn't going to gain you much of anything.
There are better things that you can do with the worksheet tabs such as
sort the worksheet tabs see SortALLsheets macro in
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets
and comment about color sheet tabs in
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs
You can rename some of your worksheetnames so that sorting will keep
groups of sheets together. i.e. k.FunctKeys, k.ShortCutKeys -