![]() |
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. |
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 |
All times are GMT +1. The time now is 01:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com