Excel - Formatting Subtotal Rows: Episode 1643

[@Fajriah]

Hi Bill, thank you so much for your sharing. It helps me a lot for my assignment!

[@excelisfun]

Pretty cool! Buggy-cool, I guess...

[@mysimonhughes]

Good trick, pity is does not stop the formatting at the last column of the data set!

[@VijayKumar-zd7ou]

Hello sir, my one query is how to many name a column and repeated some 4,5,3,7,2 time how to coloured at once in excel then sort by colour show grouping but every group show different different colour. Please help😂

[@MrXL]

Yes: see this video: ua-cam.com/video/u8F7U7W6ka4/v-deo.html

[@ChaseGausepohl]

It works in 2007, I hate how excel keeps getting worse.

[@Kayla5010]

Excel 2013 is not allowing me to select the Subtotal tool, could you possibly tell me what I might be doing wrong?

[@Kayla5010]

***** Yes that worked! Thank you so much!