ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format Painter Not working (https://www.excelbanter.com/excel-discussion-misc-queries/234875-format-painter-not-working.html)

kris

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

Please help.


Gord Dibben

Format Painter Not working
 
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.



kris

Format Painter Not working
 
Gord, a simple excel cell format width.



Gord Dibben

Format Painter Not working
 
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.



kris

Format Painter Not working
 
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.




Gord Dibben

Format Painter Not working
 
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.





kris

Format Painter Not working
 
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



All times are GMT +1. The time now is 01:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com