| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I format all comments in an Excel worksheet?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format all comments in an Excel worksheet?
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format all comments in an Excel worksheet?
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format all comments in an Excel worksheet?
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 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Comments | How to Format many at one time | Excel Discussion (Misc queries) | |||
| Change format of all comments in an Excel worksheet | Excel Discussion (Misc queries) | |||
| "how can i format all the comments in a worksheet together?" | Excel Discussion (Misc queries) | |||
| How do I change format of all comments in worksheet? | Excel Discussion (Misc queries) | |||
| How can I pre format all Excel comments | New Users to Excel | |||
Hybrid Mode
