Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2012, 09:48 PM
avie layne avie layne is offline Excel - Color Worksheet Tabs Mac OS X Excel - Color Worksheet Tabs Office for Mac 2011
Novice
Excel - Color Worksheet Tabs
 
Join Date: Feb 2012
Posts: 1
avie layne is on a distinguished road
Default Excel - Color Worksheet Tabs

I would like o be able to color/shade the worksheet tabs within my workbook. I am using Office for MAC 2008 on one machine and 2011 on the other.
Reply With Quote
  #2  
Old 02-20-2012, 05:45 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Excel - Color Worksheet Tabs Windows 7 32bit Excel - Color Worksheet Tabs Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

I am not a Mac user but I did some research online and it appears that you can only change the tab colour in 2011. This feature is not available in 2008.
Reply With Quote
  #3  
Old 02-22-2012, 01:17 PM
excelledsoftware excelledsoftware is offline Excel - Color Worksheet Tabs Windows 7 64bit Excel - Color Worksheet Tabs Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 453
excelledsoftware will become famous soon enough
Default

Quote:
Originally Posted by Colin Legg View Post
Hi,

I am not a Mac user but I did some research online and it appears that you can only change the tab colour in 2011. This feature is not available in 2008.
forgive me if I state the obviouse but You are not able to just right click on the tab and change the color? office 2003 on PC does this I would hope Mac would not make such a mistake.
Reply With Quote
  #4  
Old 02-22-2012, 02:25 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Excel - Color Worksheet Tabs Windows 7 32bit Excel - Color Worksheet Tabs Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Quote:
forgive me if I state the obviouse but You are not able to just right click on the tab and change the color?
No, it's a fair question and I agree with you that it's amazing but, according to what I've seen online, you can't do that in Excel 2008. As I mentioned in my previous post, it was enabled in Excel 2011.
Reply With Quote
  #5  
Old 11-12-2012, 04:45 PM
kymblair kymblair is offline Excel - Color Worksheet Tabs Mac OS X Excel - Color Worksheet Tabs Office for Mac 2011
Novice
 
Join Date: Nov 2012
Posts: 1
kymblair is on a distinguished road
Default Color Tabs - Excel for Mac 2011

Coloring the sheet tabs:

Hold down CONTROL and click the sheet tab.

Click Tab Color, and then click the color that you want to use.

Note To remove color from a tab, click No Fill.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Distortion trying to embed excel worksheet Sugaratias Word 0 11-26-2011 11:26 AM
Using VBA to change color of a ext box directly on worksheet Roscoe Excel Programming 0 11-21-2011 11:42 AM
New/Custom Tabs in Excel 2010 judicial85 Excel 1 09-27-2011 07:59 AM
Excel - Color Worksheet Tabs VB Code in Excel Active worksheet shakilhyd Excel 2 05-17-2010 07:50 AM
Excel - Color Worksheet Tabs mail receipent with an excel worksheet attachment jburke@holidayinnislip.co Office 1 11-14-2005 08:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft