I used to be able to double click the Format Painter to paste formatting to
multiple cells but now I'm using Excel 2007 when I double click the Format
Painter the button just pops out so I can only ever past the formatting to
one cell. It only stays in when you press it once.
Is there somewhere else that I have to set this up so that the button stays
in when you double click it?

Thanks