ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   tab background fill - color (https://www.excelbanter.com/new-users-excel/51795-tab-background-fill-color.html)

DeAnne

tab background fill - color
 
I have excel 97 - trying to help my daughter via the phone. (my program is
too old). How can we put a background color on the tabs? Thank you! DeAnne

Anne Troy

tab background fill - color
 
You can't in Excel 97.
************
Anne Troy
www.OfficeArticles.com

"DeAnne" wrote in message
...
I have excel 97 - trying to help my daughter via the phone. (my program is
too old). How can we put a background color on the tabs? Thank you!
DeAnne




Nick Hodge

tab background fill - color
 
DeAnne

Upgrade to XL XP (2002) or up.... it was only introduced in these versions

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"DeAnne" wrote in message
...
I have excel 97 - trying to help my daughter via the phone. (my program is
too old). How can we put a background color on the tabs? Thank you!
DeAnne




David McRitchie

tab background fill - color
 
Hi DeAnne,
You did not indicate what version your daughter has, if she has 2002
she would right click on the sheet tab OR on the format menu
choose sheet, then Tab Color.

If you don't have Excel 2002 there are alternatives to coloring the tabs
that make more sense to me than color.

Changing the Colors of Worksheet Tabs (#tabs)
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs
--
---
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

"DeAnne" wrote in message ...
I have excel 97 - trying to help my daughter via the phone. (my program is
too old). How can we put a background color on the tabs? Thank you! DeAnne




Anne Troy

tab background fill - color
 
RTFQ! (yelling at myself)
Nice, Dave.
************
Anne Troy
www.OfficeArticles.com

"David McRitchie" wrote in message
...
Hi DeAnne,
You did not indicate what version your daughter has, if she has 2002
she would right click on the sheet tab OR on the format menu
choose sheet, then Tab Color.

If you don't have Excel 2002 there are alternatives to coloring the tabs
that make more sense to me than color.

Changing the Colors of Worksheet Tabs (#tabs)
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs
--
---
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

"DeAnne" wrote in message
...
I have excel 97 - trying to help my daughter via the phone. (my program
is
too old). How can we put a background color on the tabs? Thank you!
DeAnne







All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com