| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change cell data without leaving cell?
(excel 2002)
Sometimes I just want to try various values in some cell. So, type a value, <enter, <up arrow, type a new value, <enter, <up arrow ... Not a big deal, but if there was a way to 'enter' the new value without leaving the cell, I'd use it. Thanks, G |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change cell data without leaving cell?
Use <ctrl and <Enter
then <F2 to get back into the cell "George" wrote: (excel 2002) Sometimes I just want to try various values in some cell. So, type a value, <enter, <up arrow, type a new value, <enter, <up arrow ... Not a big deal, but if there was a way to 'enter' the new value without leaving the cell, I'd use it. Thanks, G |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change cell data without leaving cell?
ToolsOptionsEdit.
Uncheck "move selection after enter" Gord Dibben MS Excel MVP On Fri, 02 Oct 2009 07:31:29 -0400, George wrote: (excel 2002) Sometimes I just want to try various values in some cell. So, type a value, <enter, <up arrow, type a new value, <enter, <up arrow ... Not a big deal, but if there was a way to 'enter' the new value without leaving the cell, I'd use it. Thanks, G |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Force required entry in cell before leaving that cell | Excel Worksheet Functions | |||
| Leaving Cell Blank. | Excel Worksheet Functions | |||
| Leaving a cell blank | New Users to Excel | |||
| The numbers entered change to symbols when leaving the cell | New Users to Excel | |||
| Leaving a cell blank. Not NA(), not "". | Excel Worksheet Functions | |||
![George[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
