Enter Formula without using =

  • Thread starter Brian Tankersley
  • Start date
B

Brian Tankersley

I would like to be able to enter a formula into a cell and have it not
require me to first type the equals sign.

For example, when I type

12+12

I would like for the cell to return

24

and when I edit the cell, it would show

=12+12

(e.g. Excel automatically inserts the = before the formula)

Does anyone know how to do this?
 
P

Peo Sjoblom

Tools>options>transition and select transition formula entry


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Manual or Automatic Paragraph Spacing? 2
Mail Merge Directory Conditional Page Break 0
Insert Index into a Table 1
Using <= in countifs statement 1
The sum of the same function that is used for a range of cells 2
Problem with MS Word paragraph and character styles: format getting messed up 2
Auto Fill Word Documents 4
IF formula returns FALSE 1

Top