How do I format all comments in an Excel worksheet?

's Computer Specifications

I am using Excel 2007 and want to change the font and pitch of all comments
in one go rather than doing so one by one.

's Computer Specifications

Hi,

A macro is probably your best bet. However, here is a manual method, which
is probably faster than the method you are using:

1. Choose View, Comments
2. Modify one of the comments.
3. Select the border of the comment
4. Double-click the Format Painter
5. One at a time single click each of the other comments.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"David Ashford" wrote:

> I am using Excel 2007 and want to change the font and pitch of all comments
> in one go rather than doing so one by one.

's Computer Specifications

See Debra Dalgleish's site for a macro.

http://www.contextures.com/xlcomments03.html#Format

Gord Dibben MS Excel MVP

On Tue, 3 Mar 2009 06:08:02 -0800, David Ashford <David
(E-Mail Removed)> wrote:

>I am using Excel 2007 and want to change the font and pitch of all comments
>in one go rather than doing so one by one.

's Computer Specifications

If you prefer a macro soution then visit Debra Dalgleish's wonderful site and
read
http://www.contextures.com/xlcomments03.html#Format

"Shane Devenshire" wrote:

> Hi,
>
> A macro is probably your best bet. However, here is a manual method, which
> is probably faster than the method you are using:
>
> 1. Choose View, Comments
> 2. Modify one of the comments.
> 3. Select the border of the comment
> 4. Double-click the Format Painter
> 5. One at a time single click each of the other comments.
>
> --
> If this helps, please click the Yes button.
>
> Cheers,
> Shane Devenshire
>
>
> "David Ashford" wrote:
>
> > I am using Excel 2007 and want to change the font and pitch of all comments
> > in one go rather than doing so one by one.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel 2000 how to format the comments font all comments	Delquestion	Microsoft Excel Misc	1	8th Oct 2009 02:19 PM
Excel comments moving on the worksheet	=?Utf-8?B?bWFjaGk=?=	Microsoft Excel Misc	1	14th Feb 2007 02:16 PM
Change format of all comments in an Excel worksheet	=?Utf-8?B?RXJpYyBBcm1zdHJvbmc=?=	Microsoft Excel Misc	1	24th Feb 2006 12:32 AM
Enter comments in a protected Excel worksheet	=?Utf-8?B?U1VFIEQ=?=	Microsoft Excel Worksheet Functions	1	21st Sep 2005 04:57 PM
How do I change format of all comments in worksheet?	=?Utf-8?B?Q2xhcmUgQ2FzdGxl?=	Microsoft Excel Misc	1	19th Jan 2005 03:54 PM