Copying formatting

[Francis Hookam]

There must be a slicker way of formatting a column the same as another
elsewhere in the same sheet than

Select and copying column X
the
selecting and Pasting Special Formats into column Y

....?

Francis Hookham

 

[Paul Berkowitz]

There must be a slicker way of formatting a column the same as another
elsewhere in the same sheet than

Select and copying column X
the
selecting and Pasting Special Formats into column Y

...?

What do you find un-slick about that process? It seems pretty slick to me.
Not only that, it works.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[JE McGimpsey]

There must be a slicker way of formatting a column the same as another
elsewhere in the same sheet than

Select and copying column X
the
selecting and Pasting Special Formats into column Y

Don't know about slicker, but different:

Select column X

Click on the Format Painter tool

Click on column Y header.