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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Painter and the Styles 1
Format Painter overwrites text 4
Format Painter Column Width 3
clipboard and format painter 1
Format Painter won't stay on 5
Format Painter 1
Format Painter in Excel 2007 4
Copying Conditional formatting 2

Top