Adding numbers in a single cell without using formula bar

%3CLINGO-SUB%20id%3D%22lingo-sub-2826150%22%20slang%3D%22en-US%22%3EAdding%20numbers%20in%20a%20single%20cell%20without%20using%20formula%20bar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2826150%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20pretty%20new%20to%20excel%20but%20I%20wanted%20to%20start%20tracking%20my%20spending%20and%20I%20figured%20excel%20was%20the%20easiest%20way%20to%20do%20it.%20I%20can%20use%20basic%20functions%20of%20excel%20that%20are%20useful%20for%20this%2C%20such%20as%20autosum%20and%20conditional%20formatting%2C%20but%20I%20was%20wondering%20if%20there%20was%20a%20way%20to%20get%20an%20individual%20cell%20to%20automatically%20sum%20numbers%20that%20you%20type%20into%20that%20specific%20cell%20without%20having%20to%20go%20into%20the%20format%20bar%20at%20the%20top%3F%20Not%20using%20autosum%20to%20add%20inputs%20from%20a%20bunch%20of%20cells%2C%20literally%20just%20click%20a%20cell%2C%20type%20a%20number%20and%20it%20already%20adds%20it%20to%20the%20existing%20value.%20I%20already%20know%20I'm%20going%20to%20forget%20to%20use%20the%20formula%20bar%20and%20instead%20wipe%20all%20the%20numbers%20from%20the%20cell%20by%20typing%20straight%20into%20the%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2826150%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2826311%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20numbers%20in%20a%20single%20cell%20without%20using%20formula%20bar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2826311%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1179516%22%20target%3D%22_blank%22%3E%40kaizo%3C%2FA%3E%26nbsp%3BI%20don't%20think%20that%20is%20a%20good%20idea.%20It%20is%20better%20to%20use%20a%20separate%20cell%20for%20each%20number.%20If%20you%20format%20the%20range%20of%20cells%20with%20numbers%20as%20a%20table%20(Home%20tab%2C%20Format%20as%20table)%2C%20any%20formula%20that%20points%20to%20a%20column%20in%20your%20new%20table%20will%20automatically%20work%20on%20all%20cells%20of%20that%20column.%20So%20you%20do%20not%20have%20to%20change%20your%20SUM%20formula%20when%20you%20add%20new%20numbers%20to%20the%20table.%20If%20you%20put%20your%20SUM%20above%20your%20tabel%20and%20use%20the%20View%2C%20Freeze%20panes%20option%20with%20the%20first%20cell%20in%20your%20table%20that%20contains%20a%20number%2C%20you%20can%20scroll%20down%20in%20your%20table%20and%20the%20sum%20will%20stay%20in%20view%20(see%20example).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2828603%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20numbers%20in%20a%20single%20cell%20without%20using%20formula%20bar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2828603%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1179516%22%20target%3D%22_blank%22%3E%40kaizo%3C%2FA%3E....%20I%20think%20you%20have%20a%20fundamental%20misunderstanding%20about%20how%20Excel%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%2C%20features%20like%20Autosum%20are%20merely%20alternatives%20(%22shortcuts%22%3F)%20that%20Excel%20provides%20for%20%22convenience%22.%26nbsp%3B%20Nothing%20requires%20that%20you%20use%20them.%26nbsp%3B%20I%20never%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecond%2C%20the%20Formula%20Bar%20is%20simply%20a%20place%20where%20Excel%20shows%20the%20content%20of%20a%20cell.%26nbsp%3B%20In%20other%20words%2C%20we%20%3CU%3E%3CEM%3Etype%3C%2FEM%3E%3C%2FU%3E%20into%20a%20cell%2C%20and%20it%20%3CU%3E%3CEM%3Eappears%3C%2FEM%3E%3C%2FU%3E%20in%20the%20FB.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESometimes%2C%20it%20is%20convenient%20to%20change%20the%20cell%20content%20by%20editing%20in%20the%20FB.%26nbsp%3B%20That%20is%20the%20way%20I%20operate.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20if%20you%20choose%20the%20appropriate%20option%20(%22allow%20editing%20directly%20in%20cells%22)%2C%20you%20can%20eschew%20the%20FB%20and%20type%20directly%20in%20the%20cell.%26nbsp%3B%20Select%20the%20cell%2C%20then%20press%20f2%2C%20then%20edit.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20for%20adding%20numbers%20in%20a%20single%20cell%20--%20and%20performing%20%3CU%3E%3CEM%3Eany%3C%2FEM%3E%3C%2FU%3E%20arithmetic%20--%20that%20is%20the%20purpose%20of%20formulas.%26nbsp%3B%20Certainly%2C%20it%20is%20__not__%20a%20%22bad%20idea%22.%26nbsp%3B%20We%20do%20it%20all%20the%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20not%20as%20simple%20as%20%60%60automatically%20sum%20numbers%20that%20you%20type%20into%20that%20specific%20cell%60%60.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstead%2C%20you%20have%20to%20write%20an%20expression%2C%20all%20preceded%20by%20an%20equal%20sign%20(%22%3D%22).%26nbsp%3B%20For%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D123%20%2B%20456%20%2B%20678%20%2B%2091011%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBTW%2C%20some%20people%20write%20%3D%2B123%20%2B....%26nbsp%3B%20The%20first%20plus%20is%20totally%20unnecessary.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20some%20people%20want%20to%20use%20only%20the%20numeric%20keypad%20for%20entering%20such%20formulas%20as%20well%20as%20numbers.%26nbsp%3B%20And%20apparently%2C%20the%20numeric%20keypad%20does%20not%20have%20an%20equal%20sign.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20their%20benefit%2C%20Excel%20allows%20us%20to%20enter%20formulas%20starting%20with%20plus%20(%22%2B%22)%20or%20minus%20(%22-%22)%20instead%20of%20an%20equal%20sign.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

I'm pretty new to excel but I wanted to start tracking my spending and I figured excel was the easiest way to do it. I can use basic functions of excel that are useful for this, such as autosum and conditional formatting, but I was wondering if there was a way to get an individual cell to automatically sum numbers that you type into that specific cell without having to go into the format bar at the top? Not using autosum to add inputs from a bunch of cells, literally just click a cell, type a number and it already adds it to the existing value. I already know I'm going to forget to use the formula bar and instead wipe all the numbers from the cell by typing straight into the cell.

 

Many thanks.

3 Replies

@kaizo I don't think that is a good idea. It is better to use a separate cell for each number. If you format the range of cells with numbers as a table (Home tab, Format as table), any formula that points to a column in your new table will automatically work on all cells of that column. So you do not have to change your SUM formula when you add new numbers to the table. If you put your SUM above your tabel and use the View, Freeze panes option with the first cell in your table that contains a number, you can scroll down in your table and the sum will stay in view (see example).

 

@kaizo.... I think you have a fundamental misunderstanding about how Excel works.

 

First, features like Autosum are merely alternatives ("shortcuts"?) that Excel provides for "convenience".  Nothing requires that you use them.  I never do.

 

Second, the Formula Bar is simply a place where Excel shows the content of a cell.  In other words, we type into a cell, and it appears in the FB.

 

Sometimes, it is convenient to change the cell content by editing in the FB.  That is the way I operate. 

 

But if you choose the appropriate option ("allow editing directly in cells"), you can eschew the FB and type directly in the cell.  Select the cell, then press f2, then edit.

 

As for adding numbers in a single cell -- and performing any arithmetic -- that is the purpose of formulas.

 

It is not as simple as ``automatically sum numbers that you type into that specific cell``.

 

Instead, we have to write an expression, preceded by an equal sign ("=").  For example:

 

=123 + 456 + 678 + 91011

 

BTW, some people write =+123 +....  The first plus is totally unnecessary.

 

However, some people want to use only the numeric keypad for entering such formulas as well as numbers.  And apparently, the numeric keypad does not have an equal sign.  (I do not have an NK, and I would not use it, if I did.)

 

For their benefit, Excel allows us to enter formulas starting with plus ("+") or minus ("-") instead of an equal sign.

 

@Joe User 

 

Many people have a fundamental misunderstanding of computers in general. Many people think that you enter an input value and the computer will think about it and return the expected value, or you feed a large data set into computers and it will automatically format it or move it from one cell or worksheet to another or separating the data set just by pressing a button.

 

I still remember when I first sat in front of a computer presented with a blank black screen with a blinking cursor and my first thought was... what do I do next? will this thing fizzle up and start smoking and die if I even pressed the wrong button on the keyboard? lol