ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   rekey last entry (https://www.excelbanter.com/excel-discussion-misc-queries/46239-rekey-last-entry.html)

rrupp

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.

Dave Peterson

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