ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Tab color (https://www.excelbanter.com/excel-worksheet-functions/90796-tab-color.html)

Hapitaron10

Tab color
 

wonder if anyone can help me out with this. I want to have different
color to different worksheet , any one know how?


--
Hapitaron10
------------------------------------------------------------------------
Hapitaron10's Profile: http://www.excelforum.com/member.php...o&userid=34835
View this thread: http://www.excelforum.com/showthread...hreadid=545838


Daniel CHEN

Tab color
 
Go to menu: Format/Sheet/Tab Color and select the color your like for the
active sheet only.


--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Hapitaron10"
wrote in message
...

wonder if anyone can help me out with this. I want to have different
color to different worksheet , any one know how?


--
Hapitaron10
------------------------------------------------------------------------
Hapitaron10's Profile:
http://www.excelforum.com/member.php...o&userid=34835
View this thread: http://www.excelforum.com/showthread...hreadid=545838




Dave Peterson

Tab color
 
Only in xl2002+.

Just rightclick on the tab and choose tab color.

Hapitaron10 wrote:

wonder if anyone can help me out with this. I want to have different
color to different worksheet , any one know how?

--
Hapitaron10
------------------------------------------------------------------------
Hapitaron10's Profile: http://www.excelforum.com/member.php...o&userid=34835
View this thread: http://www.excelforum.com/showthread...hreadid=545838


--

Dave Peterson

Hapitaron10

Tab color
 

thanks, Under my format menu: Format/Sheet/ I DON'T HAVE Tab Color and
???


--
Hapitaron10
------------------------------------------------------------------------
Hapitaron10's Profile: http://www.excelforum.com/member.php...o&userid=34835
View this thread: http://www.excelforum.com/showthread...hreadid=545838


Bob Phillips

Tab color
 
You need Excel 2002 (XP) or later.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Hapitaron10"
wrote in message
...

thanks, Under my format menu: Format/Sheet/ I DON'T HAVE Tab Color and
???


--
Hapitaron10
------------------------------------------------------------------------
Hapitaron10's Profile:

http://www.excelforum.com/member.php...o&userid=34835
View this thread: http://www.excelforum.com/showthread...hreadid=545838





All times are GMT +1. The time now is 12:43 AM.

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