| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Immediately jump to next cell?
I have a chart with 5 rows and in each cell will be only one number.
How to create that immediately after I insert a single number it jumps to next cell below without even pressing enter? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Immediately jump to next cell?
You cannot do this.
When you are entering data in a cell, Excel needs some type of signal that you have finished with that cell. ENTER or Tab or mouse-click or arrow out of the cell. Code will not work while in editing mode so VBA will not get you there either. Gord Dibben Excel MVP On Thu, 24 Nov 2005 21:54:51 +0100, wrote: I have a chart with 5 rows and in each cell will be only one number. How to create that immediately after I insert a single number it jumps to next cell below without even pressing enter? Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i enfoce a"auto-tab or jump" to next cell | Excel Discussion (Misc queries) | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| HOW TO JUMP TO THE LAST CELL IN A ROW? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| How do I "CTRL [" (jump to a precedent cell) from a European keybo | Excel Discussion (Misc queries) | |||
Linear Mode
