 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Increasing easily the number in a cell.
I have a very large number (8 digits, perhaps) in a cell and wish to increase marginally that number (add 2, say) without re-typing (almost) the entire string of digits. Is there an easy way (maybe holding down a simple key-combination then hitting "2") that will achieve my aim? TIA of any reply.  SignatureDB. Try touching the f2 key SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > I have a very large number (8 digits, perhaps) in a cell and wish to > increase marginally that number (add 2, say) without re-typing (almost) > the entire string of digits. Is there an easy way (maybe holding down a > simple key-combination then hitting "2") that will achieve my aim? > > TIA of any reply. Thanks for your quick reply, Don. But holding down the f2 key and hitting "2" appends a 2 to the end of the number (so that 15016283 becomes 150162832) whereas I want to increase the number itself by 2 - i.e. for it to become 15016285. Is there a simple way to do this, please? (And, similarly, a simple way to subtract that 2 from my original number?). Thanks again, SignatureDB. > Try touching the f2 key > [quoted text clipped - 7 lines] >> >> TIA of any reply. Right click sheet tab>view code>insert this>change f1 to your cell address. Now when you right click on the cell the number will be increased by 2 Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Intersect(Target, Range("f1")) Is Nothing Then Exit Sub Application.EnableEvents = False Target = Target + 2 Application.EnableEvents = True End Sub SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Thanks for your quick reply, Don. > But holding down the f2 key and hitting "2" appends a 2 to the end of [quoted text clipped - 11 lines] >>> >>> TIA of any reply. Thanks again, Don. But that solution is rather more complex than I'd hoped for - this old dog is finding it increasingly difficult to learn new tricks! It's getting late here in UK - I must leave it until tomorrow to see if I can fathom the meaning of your reply. BW's, (another) Don > Right click sheet tab>view code>insert this>change f1 to your cell > address. Now when you right click on the cell the number will be [quoted text clipped - 26 lines] >>>> >>>> TIA of any reply. Not really too complicated to tap your finger twice...... SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Thanks again, Don. But that solution is rather more complex than I'd > hoped for - this old dog is finding it increasingly difficult to learn new [quoted text clipped - 35 lines] >>>>> >>>>> TIA of any reply. Hi, A simple macro will do this for you. The following would be the simplest. Sub Increment() Range("A1").Value = Range("A1").Value + 1 End Sub Assign a button or a short-cut key to the macro. Each time it runs, your number will increase by 1. I've assumed your number is in cell A1. Change the reference as necessary. Regards - Dave. Hi DB, It depends on your actual needs and exactly what sort of functionality you require. Here are a couple of non macro ways of incrementing cells. 1) Put 2 in an empty cell and copy it. Then right click on your target cell. Select Paste Special. Check Add And OK out. (This way works well if you have a lot of cells to add 2 to) 2) Go to View>Toolbars>Forms. On the Forms toolbar select a Spinner (small box with an Up arrow and a Down arrow) Left click and drag a box to set your spinner button. Right click on the button and select format control. In the dialag box set the incremental change you want and set the cell link to a blank cell and OK out. Click on the arrows a few times to see how it works. Depending on your requirements, you can apply the spinner directly to your target cell or you can put it in another cell and reference it with a formula. As an example if you were to put =A2/10 in cell A1 put a spinner in A2 Succeessive clicks of the spinner will increase A1 in 0.1 increments The spinner won't go negative so you have to adjust the starting point to get that effect. HTH Martin > I have a very large number (8 digits, perhaps) in a cell and wish to > increase marginally that number (add 2, say) without re-typing (almost) > the entire string of digits. Is there an easy way (maybe holding down a > simple key-combination then hitting "2") that will achieve my aim? > > TIA of any reply. I recommend MartinW's first response.... SignatureWag more, bark less > I have a very large number (8 digits, perhaps) in a cell and wish to > increase marginally that number (add 2, say) without re-typing (almost) > the entire string of digits. Is there an easy way (maybe holding down a > simple key-combination then hitting "2") that will achieve my aim? > > TIA of any reply. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.