ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how can I restore Edit button to the Formula bar? (https://www.excelbanter.com/excel-discussion-misc-queries/19286-how-can-i-restore-edit-button-formula-bar.html)

JJKatty

how can I restore Edit button to the Formula bar?
 
I can't put back the Edit button on the Formula bar, the Function button has
taken over.

Gord Dibben

JJ

Do you mean the "=" sign on the formula bar?

It left Excel when version 2002(XP) was released and no workaround for it.

If you are running an older version, I don't know how it got lost.

I can run Version 97 and cannot lose the "Edit Formula" button(= sign).


Gord Dibben Excel MVP


On Fri, 25 Mar 2005 11:25:03 -0800, "JJKatty"
wrote:

I can't put back the Edit button on the Formula bar, the Function button has
taken over.



johnjrider

thank you! Finally an answer! Yes I did upgrade Excel to 2002 and thats when
I lost the "=" button, I like it more than the function button. JJ

"Gord Dibben" wrote:

JJ

Do you mean the "=" sign on the formula bar?

It left Excel when version 2002(XP) was released and no workaround for it.

If you are running an older version, I don't know how it got lost.

I can run Version 97 and cannot lose the "Edit Formula" button(= sign).


Gord Dibben Excel MVP


On Fri, 25 Mar 2005 11:25:03 -0800, "JJKatty"
wrote:

I can't put back the Edit button on the Formula bar, the Function button has
taken over.




Gord Dibben

JJ

You and a whole other bunch of people<g

Try dragging the "=" sign up to the toolbar and click on it to enter "=" then
click on the Name Box at left of formula bar.

Select your Function(s) from there.

Saves a few steps.

"=" sign can be found under ToolsCustomizeCommandsInsert category.


Gord

On Fri, 25 Mar 2005 18:23:01 -0800, "johnjrider"
wrote:

thank you! Finally an answer! Yes I did upgrade Excel to 2002 and thats when
I lost the "=" button, I like it more than the function button. JJ

"Gord Dibben" wrote:

JJ

Do you mean the "=" sign on the formula bar?

It left Excel when version 2002(XP) was released and no workaround for it.

If you are running an older version, I don't know how it got lost.

I can run Version 97 and cannot lose the "Edit Formula" button(= sign).


Gord Dibben Excel MVP


On Fri, 25 Mar 2005 11:25:03 -0800, "JJKatty"
wrote:

I can't put back the Edit button on the Formula bar, the Function button has
taken over.






All times are GMT +1. The time now is 12:33 PM.

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