Home

Format Cells Icon on Customized Toolbar

%3CLINGO-SUB%20id%3D%22lingo-sub-784174%22%20slang%3D%22en-US%22%3EFormat%20Cells%20Icon%20on%20Customized%20Toolbar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784174%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%26nbsp%3B%20DAE%20experience%20this%20problem%3A%26nbsp%3B%20I%20customize%20my%20toolbar%20to%20shortcut%20functions%20I%20use%20consistently%2C%20and%20one%20of%20those%20icons%20I%20include%20is%20the%20Format%20Cells%20icon.%26nbsp%3B%20But%20shortly%20after%20I%20insert%20that%20icon%20onto%20the%20toolbar%2C%20Excel%20changes%20the%20icon%20from%20the%20square%20Formal%20Cells%20icon%20to%20one%20with%20a%20paint%20bucket%2Fbrush%2C%20and%20grays%20it%20out%20the%20icon%20so%20it%20is%20not%20usable.%26nbsp%3B%20So%20I%20have%20to%20go%20back%20into%20the%20list%20of%20commands%2C%20remove%20the%20paint%20bucket%2Fbrush%20one%20and%20re-insert%20the%20square%20Format%20Cells%20icon%20which%20works%20for%20a%20little%20while%20then%20Excel%20again%20converts%20and%20grays%20it%20out.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20has%20a%20remedy%2C%20please%20let%20me%20know.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-784174%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787725%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20Cells%20Icon%20on%20Customized%20Toolbar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787725%22%20slang%3D%22en-US%22%3ENo%20remedy%2C%20but%20the%20easiest%20alternative%20is%20to%20use%20the%20keyboard%20short-cut%20which%20is%20control%2B1%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-790812%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20Cells%20Icon%20on%20Customized%20Toolbar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790812%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much.%26nbsp%3B%20I%20didn't%20know%20there%20was%20a%20hotkey%2Fshortcut.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMuch%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793205%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20Cells%20Icon%20on%20Customized%20Toolbar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793205%22%20slang%3D%22en-US%22%3EThat%20hotkey%20works%20for%20any%20object%20in%20Excel.%20I%20like%20it%20so%20much%20that%20I%20even%20try%20to%20use%20it%20in%20Word.%20But%20alas%2C%20in%20Word%20that%20key%20combination%20does%20not%20work.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793448%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20Cells%20Icon%20on%20Customized%20Toolbar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793448%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385816%22%20target%3D%22_blank%22%3E%40flanam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20equivalent%20Shortcut%20in%20Word%20is%26nbsp%3B%3C%2FP%3E%3CP%3ECTRL%20%2B%20D%3C%2FP%3E%3C%2FLINGO-BODY%3E
flanam
New Contributor

Hi.  DAE experience this problem:  I customize my toolbar to shortcut functions I use consistently, and one of those icons I include is the Format Cells icon.  But shortly after I insert that icon onto the toolbar, Excel changes the icon from the square Formal Cells icon to one with a paint bucket/brush, and grays it out the icon so it is not usable.  So I have to go back into the list of commands, remove the paint bucket/brush one and re-insert the square Format Cells icon which works for a little while then Excel again converts and grays it out.  

 

If anyone has a remedy, please let me know.

4 Replies
No remedy, but the easiest alternative is to use the keyboard short-cut which is control+1

@Jan Karel Pieterse 

Thank you so much.  I didn't know there was a hotkey/shortcut.

 

Much appreciated!

That hotkey works for any object in Excel. I like it so much that I even try to use it in Word. But alas, in Word that key combination does not work.

@flanam 

The equivalent Shortcut in Word is 

CTRL + D

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies