Cell Styles

%3CLINGO-SUB%20id%3D%22lingo-sub-1095817%22%20slang%3D%22en-US%22%3ECell%20Styles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1095817%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20new%20to%20Excel!%20I%20have%20the%20latest%20version%20of%20Excel%20and%20am%20taking%20a%20class.%20In%20one%20of%20the%20assignments%20I%20am%20needing%20to%20click%20on%20%22Cell%20Styles.%22%20My%20screen%2C%20however%2C%20does%20not%20have%20that%20option%20to%20click%20on.%20Is%20there%20another%20way%20to%20get%20to%20%22cell%20styles%22%20or%20is%20it%20because%20I%20have%20the%20newest%20version%20that%20it%20is%20not%20available%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1095817%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1096107%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Styles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1096107%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F509828%22%20target%3D%22_blank%22%3E%40lili_21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20a%20Mac%20myself%20(with%20latest%20Office365).%20I%20guess%20that%20this%20works%20similar%20if%20you%20are%20on%20a%20PC.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20348px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164208iB2EE0864948E824C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screenshot%202020-01-08%20at%2008.04.48.png%22%20title%3D%22Screenshot%202020-01-08%20at%2008.04.48.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1096201%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Styles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1096201%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3ECell%20styles%20is%20in%20the%20Styles%20group%20of%20the%20Home%20tab%20ribbon.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1096216%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Styles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1096216%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F509828%22%20target%3D%22_blank%22%3E%40lili_21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDepends%20on%20your%20screen%20size%20you%20could%20see%20the%20icon%20itself%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20257px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164218i49B980E6A0932EB0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eor%20set%20of%20icons%20with%20styles%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20399px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164219i250DF020054E8E98%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am new to Excel! I have the latest version of Excel and am taking a class. In one of the assignments I am needing to click on "Cell Styles." My screen, however, does not have that option to click on. Is there another way to get to "cell styles" or is it because I have the newest version that it is not available?

 

5 Replies

@lili_21 

On a Mac myself (with latest Office365). I guess that this works similar if you are on a PC.

Screenshot 2020-01-08 at 08.04.48.png

Hello,

Cell styles is in the Styles group of the Home tab ribbon.

@lili_21 

Depends on your screen size you could see the icon itself

image.png

or set of icons with styles

image.png

This problem does not appear to be linked to screen size. I have a 4k, 32 inch configured for 2560x1440 and the ribbon has plenty of unused space. I have tested by adding a custom tab with the cell style button and that displays. In preferences, Styles contains (Conditional Formatting, Format as Table and Cell Styles), but only Conditional Formatting and Format as Table are displayed. There is no 'arrow' that would allow for shifting the group to show the missing Cell Styles button. 

 

Are there any other suggestions that I can try to resolve this problem, I would prefer to have the ribbon function as designed and intended without adding a custom tab. Thanks

@swrathe 

For these two years from the initial question we have new ribbon. To my knowledge Cell Styles is not expandable any more depends on window size.