answersLogoWhite

0


Best Answer

If this feature has been protected then you must "unprotect" the worksheet first. If you do not have the password to do this then I'm afraid you are using a spreadsheet in which the creator did not want you to change such things (and they probably had a good reason to do so).

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you change color in Excel spreadsheet when cell protected?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

When you change the color of the fill in a cell in excel you are changing its?

When you change the color of the fill in a cell you are changing its format. This action applies to Microsoft Excel.


Does Microsoft Excel allow you to change font size and line color?

Yes it does.


Is it possible to change a worksheet tab color in excel 1997?

Right-click on the tab and select option for tab color.


What is it called in excel when you change the font style to bold increase the font size and change the font color?

This is referred to as "font formatting."


Which Excel feature would allow you to change the font and color of a cell based on its value?

Conditional Formatting.


What is the color of Microsoft Excel?

You can use almost any color you want with MS Excel.


What does it mean cell colour Excel?

Cell color refers to the color of the square you have selected in Excel.


How do you format and change cells color based on their changed values in Excel 2007?

You need to use Conditional Formatting.


How do Excel and Word differ in formatting?

Formatting means that you change how your text or paragraph look like. For text it means underline, bold, change of color or font size. For paragraph it means line spacing, indents etc.


Can you change color in excel chart?

Yes. Right click on the part of the chart you want to change and you will be shown the options of things to do, including changing colours.


Which elements can be modified on a chart in Excel?

Just about every element can be modified on the chart (size, color, source, legend, title, etc.). According to my Spreadsheet Applications book the six chart modicifcations include the following: size, color, font, format, scale, and style.


Does Excel allow you to change the color of worksheet tabs?

Yes it does. You have to do a right click on the tab and select tab color and then select the color you want !