When I try applying format painter in another cells in excel 2007, formating
doesn't happen.

Please help.

What type of formatting are you painting?

If Conditional Formatting you may have to look at absolute and relative
references in your rules.


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 11:46:02 -0700, kris
wrote:

When I try applying format painter in another cells in excel 2007, formating
doesn't happen.

Please help.

Gord, a simple excel cell format width.

Cells don't have a width.

Only columns have a width.

You must select entire column, click painter then select another entire
column.


Gord Dibben MS Excel MVP

On Fri, 26 Jun 2009 08:10:01 -0700, kris
wrote:

Gord, a simple excel cell format width.

wrong choice of word "cell" .. its column.

"Gord Dibben" wrote:

Cells don't have a width.

Only columns have a width.

You must select entire column, click painter then select another entire
column.


Gord Dibben MS Excel MVP

On Fri, 26 Jun 2009 08:10:01 -0700, kris
wrote:

Gord, a simple excel cell format width.

Dors this mean you still cannot use the paintbrush to format a column?


Gord

On Fri, 26 Jun 2009 18:57:01 -0700, kris
wrote:

wrong choice of word "cell" .. its column.

"Gord Dibben" wrote:

Cells don't have a width.

Only columns have a width.

You must select entire column, click painter then select another entire
column.


Gord Dibben MS Excel MVP

On Fri, 26 Jun 2009 08:10:01 -0700, kris
wrote:

Gord, a simple excel cell format width.

Dors this mean you still cannot use the paintbrush to format a column?

Yup and Yup!!

Any ideas ....
Its happening pretty much all the computers I tried.

Its Excel 2007 (12.0.6504.5001) SP2 MSO (12.0.6425.1000).

Thanks