A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I get an automatic equal sign to begin the formula bar?



 
 
Thread Tools Display Modes
  #1  
Old January 5th, 2006, 09:26 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default How do I get an automatic equal sign to begin the formula bar?

How do I get an automatic equal sign to appear in the formula bar in Excel
for Microsoft 2003? This happened for me in the 2000 version and I could
just click on it with my mouse pointer, but now all that appears is the
function sign with no equal sign after it. It makes my job a lot more time
consuming to have to type in the equal sign while building formulas. Please
help, anybody?
  #2  
Old January 5th, 2006, 11:07 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default How do I get an automatic equal sign to begin the formula bar?

The = icon disappeared in newer versions of excel (xl2002???).

You can add an = icon
Tools|customize|commands tab|Insert category
(Scroll down the list until you find the = icon)

And drag it to your favorite toolbar (nicely positioned).

It's not quite the same, but maybe it'll be sufficient for you.

scarlette belle wrote:

How do I get an automatic equal sign to appear in the formula bar in Excel
for Microsoft 2003? This happened for me in the 2000 version and I could
just click on it with my mouse pointer, but now all that appears is the
function sign with no equal sign after it. It makes my job a lot more time
consuming to have to type in the equal sign while building formulas. Please
help, anybody?


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Problem - interrupted by #VALUE! in other cells!? Ted Worksheet Functions 17 November 25th, 2005 05:18 PM
Formula to move cursor when 2 cells equal mikeburg General Discussion 2 July 8th, 2005 12:22 AM
If I type a formula into excell, and forget the "=", the equal si. Will C Holmes General Discussion 2 November 8th, 2004 05:08 PM
equal sign in function bar Laura Worksheet Functions 3 September 16th, 2004 05:02 PM
Automatic insertion of the = sign David Hall Worksheet Functions 4 March 30th, 2004 10:16 AM


All times are GMT +1. The time now is 12:06 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.