Saving a color in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1441514%22%20slang%3D%22en-US%22%3ESaving%20a%20color%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1441514%22%20slang%3D%22en-US%22%3E%3CP%3EI%20cant%20figure%20out%20why%20Excel%20does%20not%20save%20a%20color%20chosen%20from%20the%20%22More%20Colors%22%20and%20keep%20it%20saved%20in%20%22Recent%20Colors%22.%26nbsp%3B%20%26nbsp%3BI%20have%20a%20few%20colors%20that%20are%20not%20standard%20for%20text%20and%20cell%20fill%20colors.%26nbsp%3B%20Each%20time%20I%20open%20my%20excel%20data%20sheet%2C%20the%20colors%20previously%20selected%20and%20shown%20in%20the%20%22Recent%20Colors%22%20have%20all%20gone%20away%20so%20I%20have%20to%20find%20them%20again.%26nbsp%3B%20Why%20can't%20Excel%20save%20all%20colors%20in%20an%20existing%20worksheet%20in%20case%20the%20user%20wants%20to%20use%20the%20same%20color%20on%20a%20different%20cell%20and%20save%20them%20so%20that%20one%20could%20easily%20click%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1441514%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1441709%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20a%20color%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1441709%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20you%20specify%20desired%20color%20by%20clicking%20on%20More%20Colors%20in%20the%20Fill%20and%20Font%20colors%2C%20you%20will%20always%20see%20the%20specified%20colors%20in%20the%20Recent%20Colors%20bell%20Theme%20and%20Standard%20Colors%20respectively.%3CBR%20%2F%3E%3CBR%20%2F%3ERegards.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1441842%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20a%20color%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1441842%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F689538%22%20target%3D%22_blank%22%3E%40CRW7878%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eif%20you%20use%20the%20same%20custom%20colors%20repeatedly%2C%20you%20can%20create%20a%20style.%20Styles%20can%20store%20number%20formats%2C%20alignment%20font%20(including%20color)%2C%20border%20and%20fill.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20a%20cell%20that%20has%20the%20formatting%20you%20want%20to%20preserve%2C%20then%20click%20click%20the%20drop-down%20arrow%20in%20the%20styles%20gallery%20and%20select%20%22New%20Cell%20Style%22.%20Enter%20a%20name%20for%20the%20style.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20next%20time%20you%20would%20like%20a%20cell%20to%20be%20formatted%20that%20way%2C%20just%20select%20the%20style%20from%20the%20styles%20gallery.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20also%20quickly%20copy%20styles%20between%20workbooks%20by%20copying%20and%20pasting%20styled%20cells.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470429%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20a%20color%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470429%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20had%20the%20same%20issue%20for%20quite%20some%20time.%20I%20work%20with%20a%20couple%20Excel%20files%20in%20which%20the%20developers%20have%20the%20used%20custom%20fill%20colors%20that%20display%20in%20the%20Fill%20Color%20drop%20down%20each%20time%20the%20most%20recent%20version%20is%20opened%2C%20saved%20as%20a%20new%20Excel%20file%20name%2C%20and%20opened%20the%20next%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20some%20of%20my%20Excel%20files%20that%20use%20three%20Custom%20cell%20fill%20colors.%20However%2C%20after%20the%20file%20is%20saved%2C%20and%20reopened%2C%20the%20Custom%20cell%20fill%20colors%20are%20not%20shown%20in%20the%20drop%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20does%20one%20get%20Custom%20cell%20fill%20colors%20to%20save%20with%20the%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I cant figure out why Excel does not save a color chosen from the "More Colors" and keep it saved in "Recent Colors".   I have a few colors that are not standard for text and cell fill colors.  Each time I open my excel data sheet, the colors previously selected and shown in the "Recent Colors" have all gone away so I have to find them again.  Why can't Excel save all colors in an existing worksheet in case the user wants to use the same color on a different cell and save them so that one could easily click them.

5 Replies
Hello,

When you specify desired color by clicking on More Colors in the Fill and Font colors, you will always see the specified colors in the Recent Colors bell Theme and Standard Colors respectively.

Regards.

Hi @CRW7878 ,

 

if you use the same custom colors repeatedly, you can create a style. Styles can store number formats, alignment font (including color), border and fill. 

 

Select a cell that has the formatting you want to preserve, then click click the drop-down arrow in the styles gallery and select "New Cell Style". Enter a name for the style.

 

The next time you would like a cell to be formatted that way, just select the style from the styles gallery.

 

You can also quickly copy styles between workbooks by copying and pasting styled cells.

 

I have had the same issue for quite some time. I work with a couple Excel files in which the developers have the used custom fill colors that display in the Fill Color drop down each time the most recent version is opened, saved as a new Excel file name, and opened the next time.

 

I have some of my Excel files that use three Custom cell fill colors. However, after the file is saved, and reopened, the Custom cell fill colors are not shown in the drop down.

 

How does one get Custom cell fill colors to save with the file?

I had this issue, but I realise it was in a .XLS file. When I save it as .XLSX, the Recent Colors were retained.
@MG_63 jep, pay attention how u save your file