ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula bar question (https://www.excelbanter.com/excel-discussion-misc-queries/241636-formula-bar-question.html)

Susan

Formula bar question
 
in my "old" excel, (2000) my formula bar was preceeded by an equal
sign (=), which when you hover over it says "Edit Formula".
my "new" excel (2007) formula bar is now preceeded by "fx", which says
"Insert Function".
any way of my getting back "Edit Formula"? i've looked in the options
but haven't found anything.
thanks a lot for any answers!
susan

Sean Timmons

Formula bar question
 
That would just be new verbiage, but the result is the same. Instead of an =,
you get an Fx. Click on it and you can do the same things you did in 2000, so
at least it won't hurt you any...

"Susan" wrote:

in my "old" excel, (2000) my formula bar was preceeded by an equal
sign (=), which when you hover over it says "Edit Formula".
my "new" excel (2007) formula bar is now preceeded by "fx", which says
"Insert Function".
any way of my getting back "Edit Formula"? i've looked in the options
but haven't found anything.
thanks a lot for any answers!
susan


Gord Dibben

Formula bar question
 
Gone in version 2002............never to return.


Gord Dibben MS Excel MVP

On Thu, 3 Sep 2009 12:48:37 -0700 (PDT), Susan wrote:

in my "old" excel, (2000) my formula bar was preceeded by an equal
sign (=), which when you hover over it says "Edit Formula".
my "new" excel (2007) formula bar is now preceeded by "fx", which says
"Insert Function".
any way of my getting back "Edit Formula"? i've looked in the options
but haven't found anything.
thanks a lot for any answers!
susan



Susan

Formula bar question
 
rats, gone. don't want to enter a function, just want to enter the
"=" automatically. guess i'll have to do it manually. thanks to gord
& sean.
susan


On Sep 3, 4:55*pm, Sean Timmons
wrote:
That would just be new verbiage, but the result is the same. Instead of an =,
you get an Fx. Click on it and you can do the same things you did in 2000, so
at least it won't hurt you any...



"Susan" wrote:
in my "old" excel, (2000) my formula bar was preceeded by an equal
sign (=), which when you hover over it says "Edit Formula".
my "new" excel (2007) formula bar is now preceeded by "fx", which says
"Insert Function".
any way of my getting back "Edit Formula"? *i've looked in the options
but haven't found anything.
thanks a lot for any answers!
susan- Hide quoted text -


- Show quoted text -




All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com