| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enter Formula without using =
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Enter Formula without using =
Toolsoptionstransition and select transition formula entry
-- Regards, Peo Sjoblom "Brian Tankersley" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| is it possible to enter in text over a formula without deleting the formula? | Excel Discussion (Misc queries) | |||
| can you wrap formula results via a formula eg. Alt Enter | Excel Discussion (Misc queries) | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
| Cannot enter formula in a cell after removing a circular formula | Excel Worksheet Functions | |||
Linear Mode
