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

Tried in 2007 and works similar to 2003

If this post helps click Yes
---------------
Jacob Skaria


"pj" wrote:

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

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

"Jacob Skaria" wrote:

Tried in 2007 and works similar to 2003

If this post helps click Yes
---------------
Jacob Skaria


"pj" wrote:

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 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 ButtonExcel OptionsResources.


Gord Dibben MS Excel MVP

On Thu, 12 Nov 2009 06:18:01 -0800, pj wrote:

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

"Jacob Skaria" wrote:

Tried in 2007 and works similar to 2003

If this post helps click Yes
---------------
Jacob Skaria


"pj" wrote:

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