Using Format Painter on multiple cells

[pj]

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

 

[Jacob Skaria]

Tried in 2007 and works similar to 2003

If this post helps click Yes

 

[pj]

Sorry Jacob I dont know what you mean.
I know how the Format Painter is supposed to work because I have 2003 on my
laptop and 2007 on my PC at home and at work. It stays on in the 2003 version
when I double click but not on the 2007 version on both PCs.

Thank you

 

[Gord Dibben]

Jacob is saying he cannot replicate your problem.

I cannot either. D-click holds until I click to turn off.

Yours does not work properly.

I know of no setting that would disable the format painter functionality.

Try running Diagnostics from Button>Excel Options>Resources.


Gord Dibben MS Excel MVP