format painter

[Sam_Ward]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

With the format painter, can one paste the result in several cells at once, even if they're not contiguous? If so, does anyone know how?
Thanks

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

With the format painter, can one paste the result in several cells at once,
even if they're not contiguous? If so, does anyone know how?
Thanks

No you can not do that as the format is pasted when you release the mouse.
You can paste to contiguous cels, but not non-contiguous ones.

 

[Fergal Condron]

To invoke the format painter for non contiguous cells double click on the
format painter tool and then you can multi select cells that you need to
paste the formatting.

Thanks,
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.

 

[Mike Middleton]

Sam_Ward -

Select the cell with the format of interest.

Double-click the format painter icon to make it "sticky."

Click the various non-contiguous cells that you want to have the format.

When finished, click the format painter icon once to "unstick" it.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Bob Greenblatt]

Sam_Ward -

Select the cell with the format of interest.

Double-click the format painter icon to make it "sticky."

Click the various non-contiguous cells that you want to have the format.

When finished, click the format painter icon once to "unstick" it.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

OOPS, my bad. That works fine. (Double click works with most tools to keep
them persistent.)

 

[Phillip Jones]

You mean you can't while in Format painter hold down the Command key
(which on a mac is used to select non-contiguous items before clicking

No you can not do that as the format is pasted when you release the mouse.
You can paste to contiguous cels, but not non-contiguous ones.

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[Bob Greenblatt]

You mean you can't while in Format painter hold down the Command key
(which on a mac is used to select non-contiguous items before clicking

Yes, that is correct! With the format painter you select the cell containing
the desired format, the one you want to "paint" on the other cell. Then you
click on the cell (or drag through a range) when you release the mouse, the
format is painted. To do this to discontiguous cells, select the cell with
the desired format, and then double click the format paint tool. THEN you
can command click on the destination cells.

 

[CyberTaz]

<snip>

THEN you
can command click on the destination cells.

<snip>

If you dbl-clk the FP you don't have to Cmd-clk - just click any individual
cells, drag to format contiguous ranges, then click the FP to turn it off
when you're done (or press esc or execute another command)

Regards |:>)
Bob Jones
[MVP] Office:Mac