Repeat entries with numeric keypad

Using Excel 2016 with Win 10.

I have many entries to make via the number keypad. Periodically there are two numbers the same. Is there a way to reenter/repeat the same number with a single key? Ctrl-Y doesn't work & the 'repeat' command on the ribbon isn't enabled.

Cut & paste takes too much time, reentering the number is shorter. When entering several hundred numbers every keystroke savings helps!

Thanks,

Kim

Hi Ali, I need to repeat the number. Dragging the value moves it from one cell to the other (for me anyway). i.e. A1 contains 1.79, I would like the same number in A2 with a single keystroke. This may be a feature of older technologies that has gone the way of the DoDo bird.

Thanks,

Kim

Here is a somewhat roundabout way. You'll have to decide whether the data entry savings exceed the setup time

I assume col-A is your data entry column

1. Insert a new column to the right of col-A if necessary.
2. In B2 copied down as far as necessary: =IF(ISNUMBER(A2), A2, N(B1))
3. Do your data entry in col-A. Where you want to repeat a number, just hit ENTER one or several times, leaving one or more cells in col-A blank. As you do the data entry, note that col-B reflects your numerical entries - including any repetitions as you want them.
4. On completion of your data entry, select col-B, copy, paste-values, then delete col-A.

Thanks for the formula example. It works as advertised with column entries. Naturally I've chosen to put data in adjacent columns (A1 through F1) so I'll need to tweak it a little, and as you said "You'll have to decide whether the data entry savings exceed the setup time".

Thank you again for the effort.

Kim

No problem - Thanks for the feedback.