ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   what happened to the insert = at the left of the formula bar? (https://www.excelbanter.com/new-users-excel/157519-what-happened-insert-%3D-left-formula-bar.html)

vtj

what happened to the insert = at the left of the formula bar?
 
I am new to Excel 2007 and miss the ability to click the = that used to be in
the box at the left of the formula bar. It would put the beginning = in so
that a formula could be entered directly by clicking on the first cell,
entering an operator and clicking the second cell. That was very efficient.
I suspect that it still exists, I just can't find it. Thanks for any help.

Bernard Liengme

what happened to the insert = at the left of the formula bar?
 
That with XL2003; next to the Formula Bar is fx which when press inserts an
= and opens the Insert Function dialog. The same in XL 2007.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"vtj" wrote in message
...
I am new to Excel 2007 and miss the ability to click the = that used to be
in
the box at the left of the formula bar. It would put the beginning = in
so
that a formula could be entered directly by clicking on the first cell,
entering an operator and clicking the second cell. That was very
efficient.
I suspect that it still exists, I just can't find it. Thanks for any
help.





All times are GMT +1. The time now is 08:04 PM.

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