I very often find myself with a formatting that I want to apply to several specific but isolated parts of a document or worksheet, without disturbing the format of the surrounding areas.
The ideal solution would be to select the text/cell with the desired formatting, click
Format Painter and then go on a select-highlighting spree until I "turn-off" the
Format Painter option. Does such a functionality exist in Word/Excel/both?