Excel Formatting Options

%3CLINGO-SUB%20id%3D%22lingo-sub-1483763%22%20slang%3D%22en-US%22%3EExcel%20Formatting%20Options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1483763%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20reduce%20the%20number%20of%20Number%20formatting%20options%20displayed%20in%20Excel%3F%3C%2FP%3E%3CP%3EFor%20example%2C%20Currencies.%26nbsp%3B%20There%20are%20dozens%20of%20them%20and%20I%20only%20ever%20need%20to%20use%20about%206%20options.%26nbsp%3B%20I%20would%20like%20to%20be%20able%20to%20reduce%20the%20list%20so%20I%20am%20not%20constantly%20scrolling%20through%2C%20looking%20for%20the%20one%20I%20want.%3C%2FP%3E%3CP%3ESimilarly%2C%20Dates.%26nbsp%3B%20Loads%20of%20options%2C%20but%20I%20only%20need%20one%20of%20them.%3C%2FP%3E%3CP%3EI%20suspect%20the%20answer%20is%20going%20to%20be%20%22No%22%2C%20but%20maybe%20someone%20has%20found%20a%20way!!%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1483763%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1487416%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formatting%20Options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487416%22%20slang%3D%22en-US%22%3EIf%20you're%20talking%20about%20the%20Format%20Cells%20dialog%20and%20the%20formats%20which%20show%20up%20when%20you%20choose%20a%20category%20on%20the%20left%2C%20then%20no%2C%20you%20can't%20alter%20those%20items%20which%20show%20on%20the%20right.%20You%20can%2C%20however%2C%20remove%20any%20custom%20formats%20you've%20added.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1487513%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formatting%20Options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487513%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F707903%22%20target%3D%22_blank%22%3E%40Graham_Speller%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20workaround%20you%20may%20create%20few%20custom%20cell%20styles%20(uncheck%20all%20options%20except%20Number)%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20481px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200871i1695551C6801F8B2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20make%20them%20available%20to%20all%20new%20workbooks%20as%20explained%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fsave-cell-styles-to-use-in-all-new-workbooks-0b3905c5-45d0-4ad4-be39-571f445d30cb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESave%20cell%20styles%20to%20use%20in%20all%20new%20workbooks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Is there a way to reduce the number of Number formatting options displayed in Excel?

For example, Currencies.  There are dozens of them and I only ever need to use about 6 options.  I would like to be able to reduce the list so I am not constantly scrolling through, looking for the one I want.

Similarly, Dates.  Loads of options, but I only need one of them.

I suspect the answer is going to be "No", but maybe someone has found a way!!

Many thanks

2 Replies
Highlighted
If you're talking about the Format Cells dialog and the formats which show up when you choose a category on the left, then no, you can't alter those items which show on the right. You can, however, remove any custom formats you've added.
Highlighted

@Graham_Speller 

As workaround you may create few custom cell styles (uncheck all options except Number)

image.png

and make them available to all new workbooks as explained here Save cell styles to use in all new workbooks