Home |
Search |
Today's Posts |
#1
|
|||
|
|||
rekey last entry
If I type in cell a1, for example, 450, and then push enter, is there a
keystroke that I can type that will put the same thing in the next cell. In conclusion, in cell a1, I type 450 and then push enter which takes me to cell a2, is there a keystroke I can push that will put 450 in cell a2. (Like in DOS, you hit the up arrow key, for the previous command) Any help would be appreciated. |
#2
|
|||
|
|||
There's an option that tells excel which direction to move after you hit enter.
Tools|Options|Edit tab|Move Selection after Enter (You'd choose down??) then hit ctrl-d to duplicate the cell above ctrl-" (control-doublequote) will copy the formula in the cell above (exactly) rrupp wrote: If I type in cell a1, for example, 450, and then push enter, is there a keystroke that I can type that will put the same thing in the next cell. In conclusion, in cell a1, I type 450 and then push enter which takes me to cell a2, is there a keystroke I can push that will put 450 in cell a2. (Like in DOS, you hit the up arrow key, for the previous command) Any help would be appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you create a selection box for data entry within excel | Excel Discussion (Misc queries) | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Data Validation / Cell Entry | Excel Discussion (Misc queries) | |||
double-clicking a list entry | Excel Discussion (Misc queries) | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions |