Reader Raja writes in to ask,
In my spreadsheet, when I wanted to change a cell color, the palette looked like this than the conventional. Its not happening always.
Only a few examples. But when I try to open and close the same file several times, its working fine.
Why is it so? Need your help to solve this.
This happens often in excel 2003 and earlier versions and is annoying when you like to work with certain colors and see them missing from the palette. (if you are wondering, the color management in excel 2007 is much more complicated, we will save it for another day)
Here are few reasons why this might be happening:
- The workbook you have opened has a different palette than the default color scheme of excel 2003. Someone might have changed the colors and now excel is showing you the updated colors.
- You have some excel add-ins that are changing the colors through VBA either when you run them or when you open certain workbooks.
And Here is how you can fix it:
Just go to Menu > Tools > Options > Colors tab, click on “Reset” button. This will reset your palette to excel 2003 default settings.Save the workbook and the colors should now be adjusted as per default scheme.
While there, you can also modify colors if you dont like the default scheme.
More on Excel Colors : How to surpass the 56 color limit in excel 2003 and earlier ?
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Make a Dynamic Chart using Data Filters||A Good Bubble Chart About the Bust »|