Home

How can I edit Automatic Styles applied to Data Groups (Outlines) in Excel on Mac?

%3CLINGO-SUB%20id%3D%22lingo-sub-389294%22%20slang%3D%22en-US%22%3EHow%20can%20I%20edit%20Automatic%20Styles%20applied%20to%20Data%20Groups%20(Outlines)%20in%20Excel%20on%20Mac%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389294%22%20slang%3D%22en-US%22%3E%3CP%3EAccording%20to%20the%20Excel%20for%20Mac%20Help%20documentation%3A%3C%2FP%3E%3CP%3E%22%3CSPAN%3EFor%20outlined%20rows%2C%20Microsoft%20Excel%20uses%20styles%20such%20as%20RowLevel_1%20and%20RowLevel_2%20.%20For%20outlined%20columns%2C%20Excel%20uses%20styles%20such%20as%20ColLevel_1%20and%20ColLevel_2.%20These%20styles%20use%20bold%2C%20italic%2C%20and%20other%20text%20formats%20to%20differentiate%20the%20summary%20rows%20or%20columns%20in%20your%20data.%20By%20changing%20the%20way%20each%20of%20these%20styles%20is%20defined%2C%20you%20can%20apply%20different%20text%20and%20cell%20formats%20to%20customize%20the%20appearance%20of%20your%20outline.%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBut%20nowhere%20does%20it%20state%20how%2Fwhere%20I%20can%20change%20the%20properties%20of%20these%20styles.%20For%20example%2C%20how%20can%20I%20edit%20the%20properties%20for%20RowLevel_1%20to%20make%20it%20Bold%2C%2014%20pt%2C%20etc.%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-389294%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-389304%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20edit%20Automatic%20Styles%20applied%20to%20Data%20Groups%20(Outlines)%20in%20Excel%20on%20Mac%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389304%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F308884%22%20target%3D%22_blank%22%3E%40evomimic%3C%2FA%3E%26nbsp%3B%2C%20at%20least%20for%20Windows%20you%20may%20select%20such%20style%20(it%20will%20appear%20in%20Styles%20on%20ribbon%20if%20you%20focus%20on%20cell%20with%20outlined%20result)%2C%20right%20click%20on%20it%20and%20modify.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20288px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F100234i9681C9D24BFF0ECA%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%3E%26nbsp%3BI%20guess%20on%20Mac%20it%20shall%20be%20similar.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
evomimic
Occasional Visitor

According to the Excel for Mac Help documentation:

"For outlined rows, Microsoft Excel uses styles such as RowLevel_1 and RowLevel_2 . For outlined columns, Excel uses styles such as ColLevel_1 and ColLevel_2. These styles use bold, italic, and other text formats to differentiate the summary rows or columns in your data. By changing the way each of these styles is defined, you can apply different text and cell formats to customize the appearance of your outline."

 

But nowhere does it state how/where I can change the properties of these styles. For example, how can I edit the properties for RowLevel_1 to make it Bold, 14 pt, etc.?

1 Reply
Highlighted

@evomimic , at least for Windows you may select such style (it will appear in Styles on ribbon if you focus on cell with outlined result), right click on it and modify.

image.png

 I guess on Mac it shall be similar.

Related Conversations
Excel Help - Stacking IF Formulas
MaddieLB in Excel on
0 Replies
Convert string to number of days
arjsharm in Excel on
0 Replies
Header
MaryUMF in Excel on
1 Replies