ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Having to key the equal sign to start a formula (https://www.excelbanter.com/excel-worksheet-functions/70345-having-key-equal-sign-start-formula.html)

Bruce

Having to key the equal sign to start a formula
 
Is there a shortcut key in excel that you could skip having to type the equal
sign (=) before the mathematical operation you want in a cell?

In other words, in stead of =2+2, being able to format cells ahead of time
or click some other generic setting or whatever method to where you would
just type 2+2 in a cell and it would automatically know you wanted to add
those numbers together in the cell rather than it coming up with the label
2+2? Then move to another cell and type 6*3 or whatever else you wanted?

Thanks,


Bruce

Paul B

Having to key the equal sign to start a formula
 
Bruce, you can also use a + sign
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Bruce" wrote in message
...
Is there a shortcut key in excel that you could skip having to type the
equal
sign (=) before the mathematical operation you want in a cell?

In other words, in stead of =2+2, being able to format cells ahead of time
or click some other generic setting or whatever method to where you would
just type 2+2 in a cell and it would automatically know you wanted to add
those numbers together in the cell rather than it coming up with the label
2+2? Then move to another cell and type 6*3 or whatever else you wanted?

Thanks,


Bruce





All times are GMT +1. The time now is 11:38 PM.

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