ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Change button right before the formula field (https://www.excelbanter.com/excel-discussion-misc-queries/62052-change-button-right-before-formula-field.html)

STefan Nilsson

Change button right before the formula field
 
Hello everyone,

Right before where you enter values/formulas you have a button.
In some Excel versions it is a "=" button that you can push this if you want
to.
Now I have a FUNCTION button there instead and that is somewhat irretating.

Does someone know how I can change the button right before the formulafield?

Dave Peterson

Change button right before the formula field
 
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.

STefan Nilsson wrote:

Hello everyone,

Right before where you enter values/formulas you have a button.
In some Excel versions it is a "=" button that you can push this if you want
to.
Now I have a FUNCTION button there instead and that is somewhat irretating.

Does someone know how I can change the button right before the formulafield?


--

Dave Peterson


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

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