equal sign on the formula bar gone

  • Thread starter Federico Borrego E.
  • Start date
F

Federico Borrego E.

In the PC version of Excel there used to be an equal sign on the formula
bar to rapidly change a number into a formula for calculations and stuff.
Now it¹s gone. Someone knows how to get it back there?

Thanks,

Mr. Borrego
 
N

Norman Harker

Hi Federico!

Try:

Tools > Customize > Commands Tab > Insert classification
Select the = and drag it up to a toolbar
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
P

Peo Sjoblom

Hi Norman,

I don't think that what the OP wanted in his multipost, I believe he wants
the functionality of the equal sign pre 2002 where it started a formula with
the contents of
the selected cell. This equal sign replaces what's in the selected cell.
 
N

Norman Harker

D

Dave Peterson

You could create macro and add a custom button to your favorite toolbar.

the macro could look something like:

Option Explicit
Sub addEquals()
SendKeys "{F2}{Home}={End}"
End Sub
 
Top