ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to locate the formula icon on toolbars? (https://www.excelbanter.com/excel-discussion-misc-queries/157802-how-locate-formula-icon-toolbars.html)

Eric

How to locate the formula icon on toolbars?
 
Does anyone have any suggestions on how to locate the formula icon on
toolbars under Office 2003?
In Office 2000, the formula icon is usually located in the default toolbars,
but this icon cannot be found under Office 2003. Does anyone have any
suggestons on how to make this icon appear in toolbars?
Thanks in advance for any suggestions
Eric

Roger Govier[_3_]

How to locate the formula icon on toolbars?
 
Hi Eric

It was replaced with the fx icon, which takes you to the list of functions
available, and help with their construction.

If you are looking for the feature where pressing the = icon showed the
result of the formula calculation, this can be achieved by pressing F2,
followed by F9.
Once you have seen the result, press Esc (or Ctrl+Z) to return to seeing the
formula.

Once you have pressed F2, you can highlight just part of a formula and press
F(, to see what that portion is returning.

--
Regards
Roger Govier



"Eric" wrote in message
...
Does anyone have any suggestions on how to locate the formula icon on
toolbars under Office 2003?
In Office 2000, the formula icon is usually located in the default
toolbars,
but this icon cannot be found under Office 2003. Does anyone have any
suggestons on how to make this icon appear in toolbars?
Thanks in advance for any suggestions
Eric





All times are GMT +1. The time now is 07:13 AM.

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