| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comment ballon and equal sign
How do I make the comment ballon large enough to show all of the comment and
what happened to the equal sign in the formula bar in excel 2007? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comment ballon and equal sign
Edit the comment as in previous versions and drag the comment balloon to the
size you want. As to the equal sign in the formula bar, it is still there in Excel 2007 as it was in previous versions.. Tyro "jggsfl" wrote in message ... How do I make the comment ballon large enough to show all of the comment and what happened to the equal sign in the formula bar in excel 2007? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comment ballon and equal sign
Thank you, I was able to resize the comment box. Still can not find the = in
the fomula bar, I only show the insert function button. Is there something I have to select on? "Tyro" wrote: Edit the comment as in previous versions and drag the comment balloon to the size you want. As to the equal sign in the formula bar, it is still there in Excel 2007 as it was in previous versions.. Tyro "jggsfl" wrote in message ... How do I make the comment ballon large enough to show all of the comment and what happened to the equal sign in the formula bar in excel 2007? Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comment ballon and equal sign
The equal sign appears automatically in Excel 2007.
If you enter text in a cell, no equal sign as in previous versions If you enter a number, you get an equal sign as in previous versions. If you enter a formula, you get an equal sign as in previous versions. Tyro "jggsfl" wrote in message ... Thank you, I was able to resize the comment box. Still can not find the = in the fomula bar, I only show the insert function button. Is there something I have to select on? "Tyro" wrote: Edit the comment as in previous versions and drag the comment balloon to the size you want. As to the equal sign in the formula bar, it is still there in Excel 2007 as it was in previous versions.. Tyro "jggsfl" wrote in message ... How do I make the comment ballon large enough to show all of the comment and what happened to the equal sign in the formula bar in excel 2007? Thank you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comment ballon and equal sign
not sure if this is a version thing , but if you go and edit the coments,
then you should be able to size the box = look for the white dots in the corner of the comments box "jggsfl" wrote: How do I make the comment ballon large enough to show all of the comment and what happened to the equal sign in the formula bar in excel 2007? Thank you. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comment ballon and equal sign
You can use code to modify the size of all the comments.
Debra Dalgleish has some sample code he http://contextures.com/xlcomments03.html#Resize The equal sign on the formula bar disappeared with xl2003. Maybe you can add the equal sign to the QAT and use it from there. It's not quite the same, but it may be sufficient for you. jggsfl wrote: How do I make the comment ballon large enough to show all of the comment and what happened to the equal sign in the formula bar in excel 2007? Thank you. -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comment ballon and equal sign
Code??? Select the comment and edit. Make the comment container as big as
you wish, format at will! Color too! Excel 2007 puts an =sign in the formula bar where warranted. No differences from previous versions. Tyro "Dave Peterson" wrote in message ... You can use code to modify the size of all the comments. Debra Dalgleish has some sample code he http://contextures.com/xlcomments03.html#Resize The equal sign on the formula bar disappeared with xl2003. Maybe you can add the equal sign to the QAT and use it from there. It's not quite the same, but it may be sufficient for you. jggsfl wrote: How do I make the comment ballon large enough to show all of the comment and what happened to the equal sign in the formula bar in excel 2007? Thank you. -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comment ballon and equal sign
xl2002 and below had an equal sign icon that was near the fx button on the
formula bar. It disappeared in xl2003. And if I had more than a few comments, I wouldn't want to do them manually. Tyro wrote: Code??? Select the comment and edit. Make the comment container as big as you wish, format at will! Color too! Excel 2007 puts an =sign in the formula bar where warranted. No differences from previous versions. Tyro "Dave Peterson" wrote in message ... You can use code to modify the size of all the comments. Debra Dalgleish has some sample code he http://contextures.com/xlcomments03.html#Resize The equal sign on the formula bar disappeared with xl2003. Maybe you can add the equal sign to the QAT and use it from there. It's not quite the same, but it may be sufficient for you. jggsfl wrote: How do I make the comment ballon large enough to show all of the comment and what happened to the equal sign in the formula bar in excel 2007? Thank you. -- Dave Peterson -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comment ballon and equal sign
Ps. Here's an image from xl97.
http://www.marintellect.com/help_topics/excel/97/ Notice the equal sign to the left of the formula bar. That doesn't exist anymore in xl2003: http://www.guidesandtutorials.com/im...el_screen1.gif or xl2007: http://www.geekpedia.com/gallery/ful...cel%202007.jpg Dave Peterson wrote: xl2002 and below had an equal sign icon that was near the fx button on the formula bar. It disappeared in xl2003. And if I had more than a few comments, I wouldn't want to do them manually. Tyro wrote: Code??? Select the comment and edit. Make the comment container as big as you wish, format at will! Color too! Excel 2007 puts an =sign in the formula bar where warranted. No differences from previous versions. Tyro "Dave Peterson" wrote in message ... You can use code to modify the size of all the comments. Debra Dalgleish has some sample code he http://contextures.com/xlcomments03.html#Resize The equal sign on the formula bar disappeared with xl2003. Maybe you can add the equal sign to the QAT and use it from there. It's not quite the same, but it may be sufficient for you. jggsfl wrote: How do I make the comment ballon large enough to show all of the comment and what happened to the equal sign in the formula bar in excel 2007? Thank you. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comment ballon and equal sign
No reason for it to exist. Simply type it in the cell where you're entering
the formula. Are you telling me you need to have Excel type it for you by pressing the equal sign???? Tyro "Dave Peterson" wrote in message ... Ps. Here's an image from xl97. http://www.marintellect.com/help_topics/excel/97/ Notice the equal sign to the left of the formula bar. That doesn't exist anymore in xl2003: http://www.guidesandtutorials.com/im...el_screen1.gif or xl2007: http://www.geekpedia.com/gallery/ful...cel%202007.jpg Dave Peterson wrote: xl2002 and below had an equal sign icon that was near the fx button on the formula bar. It disappeared in xl2003. And if I had more than a few comments, I wouldn't want to do them manually. Tyro wrote: Code??? Select the comment and edit. Make the comment container as big as you wish, format at will! Color too! Excel 2007 puts an =sign in the formula bar where warranted. No differences from previous versions. Tyro "Dave Peterson" wrote in message ... You can use code to modify the size of all the comments. Debra Dalgleish has some sample code he http://contextures.com/xlcomments03.html#Resize The equal sign on the formula bar disappeared with xl2003. Maybe you can add the equal sign to the QAT and use it from there. It's not quite the same, but it may be sufficient for you. jggsfl wrote: How do I make the comment ballon large enough to show all of the comment and what happened to the equal sign in the formula bar in excel 2007? Thank you. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comment ballon and equal sign
I don't have an = sign in my version of Excel 2002.
-- Biff Microsoft Excel MVP "Dave Peterson" wrote in message ... Ps. Here's an image from xl97. http://www.marintellect.com/help_topics/excel/97/ Notice the equal sign to the left of the formula bar. That doesn't exist anymore in xl2003: http://www.guidesandtutorials.com/im...el_screen1.gif or xl2007: http://www.geekpedia.com/gallery/ful...cel%202007.jpg Dave Peterson wrote: xl2002 and below had an equal sign icon that was near the fx button on the formula bar. It disappeared in xl2003. And if I had more than a few comments, I wouldn't want to do them manually. Tyro wrote: Code??? Select the comment and edit. Make the comment container as big as you wish, format at will! Color too! Excel 2007 puts an =sign in the formula bar where warranted. No differences from previous versions. Tyro "Dave Peterson" wrote in message ... You can use code to modify the size of all the comments. Debra Dalgleish has some sample code he http://contextures.com/xlcomments03.html#Resize The equal sign on the formula bar disappeared with xl2003. Maybe you can add the equal sign to the QAT and use it from there. It's not quite the same, but it may be sufficient for you. jggsfl wrote: How do I make the comment ballon large enough to show all of the comment and what happened to the equal sign in the formula bar in excel 2007? Thank you. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula bar doesn't have an equal sign | Excel Worksheet Functions | |||
| Why a plus sign after the equal sign? | Excel Discussion (Misc queries) | |||
| EQUAL SIGN | Excel Discussion (Misc queries) | |||
| Equal Sign Issue | Excel Worksheet Functions | |||
| why does Equal sign not appear on the formula bar | Excel Discussion (Misc queries) | |||
Hybrid Mode
