Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 407
Default Formatting Comments

For some reason, the format on all my cell comments appears in a large bold
font. I'd like to de-bold and make the font size smaller. I do not know
how to edit this. EXCEL help says to choose comments from the format menu,
but, if they mean the format dropdown, I see no such thing there.

Help, please. Editing this manually is a pain!

Thanks!
Dean


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Formatting Comments

Hi Dean

See Debra's site
http://www.contextures.com/xlcomments01.html#Format

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dean" wrote in message ...
For some reason, the format on all my cell comments appears in a large bold font. I'd like to de-bold and make the font size
smaller. I do not know how to edit this. EXCEL help says to choose comments from the format menu, but, if they mean the format
dropdown, I see no such thing there.

Help, please. Editing this manually is a pain!

Thanks!
Dean



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 407
Default Formatting Comments

I want to reformat all text, even including my name, which appears at the
beginning. I figured out how to do this except for the name. Can the name
not be done?

Before answering, let me clarify. Yes, I am successful, even with the name,
when doing an individual cell. It;'s just that when I go to insert another
comment, the change does not get saved as a "global" desired change within
the worksheet - and that's what I want. In other words, I can also change
the font for my name "Dean:". but only for the cell being edited, not all
cells to begin with.

Thanks!
Dean

"Ron de Bruin" wrote in message
...
Hi Dean

See Debra's site
http://www.contextures.com/xlcomments01.html#Format

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dean" wrote in message
...
For some reason, the format on all my cell comments appears in a large
bold font. I'd like to de-bold and make the font size smaller. I do not
know how to edit this. EXCEL help says to choose comments from the
format menu, but, if they mean the format dropdown, I see no such thing
there.

Help, please. Editing this manually is a pain!

Thanks!
Dean





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Formatting Comments

Also on Debra's site
http://www.contextures.com/xlcomments02.html#Default

Ans see this macro
http://www.contextures.com/xlcomments03.html#Formatted

Look for more tips on her site


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dean" wrote in message ...
I want to reformat all text, even including my name, which appears at the beginning. I figured out how to do this except for the
name. Can the name not be done?

Before answering, let me clarify. Yes, I am successful, even with the name, when doing an individual cell. It;'s just that when
I go to insert another comment, the change does not get saved as a "global" desired change within the worksheet - and that's what
I want. In other words, I can also change the font for my name "Dean:". but only for the cell being edited, not all cells to
begin with.

Thanks!
Dean

"Ron de Bruin" wrote in message ...
Hi Dean

See Debra's site
http://www.contextures.com/xlcomments01.html#Format

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dean" wrote in message ...
For some reason, the format on all my cell comments appears in a large bold font. I'd like to de-bold and make the font size
smaller. I do not know how to edit this. EXCEL help says to choose comments from the format menu, but, if they mean the format
dropdown, I see no such thing there.

Help, please. Editing this manually is a pain!

Thanks!
Dean







  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 407
Default Formatting Comments

Those are both interesting, but I'm not sure if the former helps my problem.
And I'm not sure if the latter allows me to include my name along with the
text of my comment, both in the same reduced font size and debolded. For
now, it looks like I cannot change the default for the font and size of my
name (Dean:) at the beginning of the comment, which I do want to have. Do
you know if that can be done, hopefully without a macro?

Thanks!

Dean


"Ron de Bruin" wrote in message
...
Also on Debra's site
http://www.contextures.com/xlcomments02.html#Default

Ans see this macro
http://www.contextures.com/xlcomments03.html#Formatted

Look for more tips on her site


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dean" wrote in message
...
I want to reformat all text, even including my name, which appears at the
beginning. I figured out how to do this except for the name. Can the
name not be done?

Before answering, let me clarify. Yes, I am successful, even with the
name, when doing an individual cell. It;'s just that when I go to insert
another comment, the change does not get saved as a "global" desired
change within the worksheet - and that's what I want. In other words, I
can also change the font for my name "Dean:". but only for the cell being
edited, not all cells to begin with.

Thanks!
Dean

"Ron de Bruin" wrote in message
...
Hi Dean

See Debra's site
http://www.contextures.com/xlcomments01.html#Format

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dean" wrote in message
...
For some reason, the format on all my cell comments appears in a large
bold font. I'd like to de-bold and make the font size smaller. I do
not know how to edit this. EXCEL help says to choose comments from the
format menu, but, if they mean the format dropdown, I see no such thing
there.

Help, please. Editing this manually is a pain!

Thanks!
Dean











  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Formatting Comments

Maybe this

http://www.contextures.com/xlcomments02.html#User
Delete the name

And include your name in the text


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dean" wrote in message ...
Those are both interesting, but I'm not sure if the former helps my problem. And I'm not sure if the latter allows me to include
my name along with the text of my comment, both in the same reduced font size and debolded. For now, it looks like I cannot
change the default for the font and size of my name (Dean:) at the beginning of the comment, which I do want to have. Do you know
if that can be done, hopefully without a macro?

Thanks!

Dean


"Ron de Bruin" wrote in message ...
Also on Debra's site
http://www.contextures.com/xlcomments02.html#Default

Ans see this macro
http://www.contextures.com/xlcomments03.html#Formatted

Look for more tips on her site


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dean" wrote in message ...
I want to reformat all text, even including my name, which appears at the beginning. I figured out how to do this except for the
name. Can the name not be done?

Before answering, let me clarify. Yes, I am successful, even with the name, when doing an individual cell. It;'s just that
when I go to insert another comment, the change does not get saved as a "global" desired change within the worksheet - and
that's what I want. In other words, I can also change the font for my name "Dean:". but only for the cell being edited, not all
cells to begin with.

Thanks!
Dean

"Ron de Bruin" wrote in message ...
Hi Dean

See Debra's site
http://www.contextures.com/xlcomments01.html#Format

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dean" wrote in message ...
For some reason, the format on all my cell comments appears in a large bold font. I'd like to de-bold and make the font size
smaller. I do not know how to edit this. EXCEL help says to choose comments from the format menu, but, if they mean the
format dropdown, I see no such thing there.

Help, please. Editing this manually is a pain!

Thanks!
Dean











Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditionally formatting comments LindaJane Excel Discussion (Misc queries) 1 September 8th 08 06:51 PM
Formatting cell comments in VB Brettjg Excel Discussion (Misc queries) 1 November 4th 07 11:41 PM
Conditional Formatting for Comments Daren Excel Worksheet Functions 1 June 28th 07 02:14 AM
formatting comments newyorkjoy Excel Discussion (Misc queries) 0 March 14th 07 01:20 AM
formatting of comments steve Excel Worksheet Functions 3 May 7th 05 01:18 AM


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"