Can I change the color of the worksheet tabs in my workbook? - In a word, no. It would certainly be helpful to be able to color-code your worksheet tabs. For some reason, Microsoft hasn't implemented this feature, which has been available in 1-2-3 and Quattro Pro for quite a while. - Microsoft Excel Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

MICROSOFT OFFICE

MICROSOFT EXCEL

DETAILS

Question: Can I change the color of the worksheet tabs in my workbook?

Answer: In a word, no. It would certainly be helpful to be able to color-code your worksheet tabs. For some reason, Microsoft hasn't implemented this feature, which has been available in 1-2-3 and Quattro Pro for quite a while.

Category	Microsoft Excel Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9255 users
Added on	9/24/2012 5:30:25 AM
Views	70967
Rate it!

Question: Can I change the color of the worksheet tabs in my workbook?

Answer:

In a word, no. It would certainly be helpful to be able to color-code your worksheet tabs. For some reason, Microsoft hasn't implemented this feature, which has been available in 1-2-3 and Quattro Pro for quite a while. Source: CoolInterview.com

well by right clicking on tab you want to change the colour, you can select the colour of your choice. Guess i m getting the question right. This menu of color change is known as Format Tab Color. Source: CoolInterview.com

Answered by: Cute | Date: 11/1/2007 |

Contact Cute

In MS Excel 2007, We can achieve this by right clicking on the work sheet tab and selecting a color from "Tab Color".

Hope this answers your question. Source: CoolInterview.com

Answered by: godfather | Date: 2/14/2010 |

Contact godfather

use conditional formatting..its helps in colouring Source: CoolInterview.com

Answered by: reema | Date: 7/18/2010 |

Contact reema

how we can creat the new macro in the ms excel Source: CoolInterview.com

Answered by: Riya Rawat | Date: 8/12/2010 |

Contact Riya Rawat

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	When I enter a value, it appears with two decimal places. For example, when I enter 154 it shows up as 1.54. What's wrong?	View Answer
	Can I write VBA code to protect or unprotect my VB Project?	View Answer
	Is my Excel 97 (or later) add-in secure?	View Answer
	Is my Excel 97 (or later) add-in secure?	View Answer
	Is my Excel 5/95 add-in secure?	View Answer
	What if I'm still using Excel 5/95?	View Answer
	How can I prevent others from viewing or changing my VBA code?	View Answer
	How can I distribute a workbook such that it can't be copied?	View Answer
	How can I prevent a user for adding or deleting sheets?	View Answer
	If I require a password to open my workbook, is it secure?	View Answer
	The Save Options dialog box (described above) also has a "Password to modify" field. What's that for?	View Answer
	How can I save a workbook so a password is required to open it?	View Answer
	What types of workbook protection are available?	View Answer
	Can I prevent someone from copying the cells in my worksheet and pasting them to a new worksheet?	View Answer
	How can I hide a worksheet so it can't be unhidden?	View Answer
	OK, I protected my worksheet with a password. Now I can't remember the password I used.	View Answer
	Are there any other reasons to protect a worksheet?	View Answer
	So are you saying that protecting a worksheet is pointless?	View Answer
	If I protect my worksheet with a password, is it really secure?	View Answer
	Can I set things up so my VBA macro can make changes to Locked cells on a protected sheet?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Microsoft Excel Interview Questions & Answers - Exam Mode / Learning Mode