Format Painter Not working

K

kris

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

Please help.
 
G

Gord Dibben

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
 
G

Gord Dibben

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
 
K

kris

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

Gord Dibben said:
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
Click to expand...
 
K

kris

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
 
Top