Excel for Mac - Format A Slicer

%3CLINGO-SUB%20id%3D%22lingo-sub-2470677%22%20slang%3D%22en-US%22%3EExcel%20for%20Mac%20-%20Format%20A%20Slicer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2470677%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20curious%20why%20it's%20impossible%20to%20format%20a%20slicer%20on%20Excel%20for%20Mac%3F%20I've%20created%20a%20beautiful%20dashboard%20and%20the%20slicers%20are%20ugly%20as%20sin%20with%20no%20way%20to%20change%20the%20formatting%20(fill%2C%20border%2C%20etc.).%20Any%20tutorial%20shows%20a%20%22Format%20Whole%20Slicer%22%20option%20that%20does%20not%20exist%20on%20my%20menu.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-06-22%20at%201.20.20%20PM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F290533iF8744234FE22F08B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-06-22%20at%201.20.20%20PM.png%22%20alt%3D%22Screen%20Shot%202021-06-22%20at%201.20.20%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2470677%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2473494%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%20-%20Format%20A%20Slicer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2473494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1085352%22%20target%3D%22_blank%22%3E%40LTarbutton%3C%2FA%3E%26nbsp%3BOn%20a%20Mac%20myself.%20Just%20Googled%20for%20%22format%20slicer%20Excel%22%20and%20bumped%20on%20to%20the%20site%20in%20the%20link%20below.%20and%20there%20are%20many%20more.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.goodly.co.in%2Fslicer-formatting-tricks%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.goodly.co.in%2Fslicer-formatting-tricks%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlthough%20it%20shows%20screenshots%20for%20the%20PC%2C%20the%20Mac%20menus%20and%20button%20are%20very%20similar%20and%20I%20could%20follow%20the%20steps%20to%20modify%20and%20reformat%20slicers.%20Your%20picture%20confirms%20that%20you%20have%20come%20as%20far%20as%20duplicating%20an%20existing%20slicer%20style%20that%20you%20now%20can%20modify.%20More%20about%20that%20in%20the%20above%20link.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm curious why it's impossible to format a slicer on Excel for Mac? I've created a beautiful dashboard and the slicers are ugly as sin with no way to change the formatting (fill, border, etc.). Any tutorial shows a "Format Whole Slicer" option that does not exist on my menu. 

Screen Shot 2021-06-22 at 1.20.20 PM.png

1 Reply

@LTarbutton On a Mac myself. Just Googled for "format slicer Excel" and bumped on to the site in the link below. and there are many more.

https://www.goodly.co.in/slicer-formatting-tricks/ 

Although it shows screenshots for the PC, the Mac menus and button are very similar and I could follow the steps to modify and reformat slicers. Your picture confirms that you have come as far as duplicating an existing slicer style that you now can modify. More about that in the above link.