View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default comment ballon and equal sign

I simply enter my formulas preceded by an = sign. Why would you want to move
the mouse over hundreds of yards of territory to get the to = sign on the
formula bar??? hehe :) Well, I guess some people will to anything to avoid a
keystroke even if it means spending a lot of time and effort.


"Dave Peterson" wrote in message
...
Nope. I can say that I don't ever remember using it.

But from the complaints I saw in these newsgroups, lots and lots of people
liked
to use it.

Tyro wrote:

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


--

Dave Peterson