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? |
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? |
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 |
All times are GMT +1. The time now is 01:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com