Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible ? Automatic cell entry
I have to ad up in individually in cells innumerable amounts, unfortunately I
have to jump from one cell to the other, put the cursor at the end of the already entered formula (something like this: 67+45+2+89+7897+124457+5+2154) press "+" and the additional amount. Is there a Private Sub that would add the plus-sign whenever I select a cell and press a certain simple key? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible ? Automatic cell entry
You might try hitting <F2 after clicking in a cell.
Then just hit +, and enter the new value. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Tatebana" wrote in message ... I have to ad up in individually in cells innumerable amounts, unfortunately I have to jump from one cell to the other, put the cursor at the end of the already entered formula (something like this: 67+45+2+89+7897+124457+5+2154) press "+" and the additional amount. Is there a Private Sub that would add the plus-sign whenever I select a cell and press a certain simple key? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible ? Automatic cell entry
Hi Tatebana,
May or may not be what you are looking for. At the bottom of the screen just above the windows taskbar is an excel bar (forgotten it's name). Right click on this bar and make sure sum is ticked. Then select a cell, hold down the ctrl button and continue to select cells the bar will show a progressive total of all the cells you select. HTH Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Data Entry | Excel Discussion (Misc queries) | |||
Automatic data entry | Excel Discussion (Misc queries) | |||
Automatic cell entry | Excel Discussion (Misc queries) | |||
automatic address and phone cell entry | Excel Worksheet Functions | |||
Automatic Date Entry | Excel Worksheet Functions |