Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 1 down vote accepted

The functionality to copy formatting from a selection to more than one place exists in Word, you simply need to double click the Format Painter button in order to apply formatting to multiple locations.

For Excel I know that the format painter exists, hopefully double clicking works there as well.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .