Sequentially Inputting Information

You can do more if you like.

First, the range selected need not be contiguous. So it could be E9, F6, H3, B5, aand F11.

Second, you can move using either Enter or Tab. And move in reverse with either key in combo with Shift.

Third, you can create such ranges in probably many ways, but the absolute simplest is putting a formula in a cell like this one:

=E9,F6,H3,B5,F11

(It can take ranges like A1:A5, Named Ranges, and so on. Haven't ever tried it with LET or other such things, but maybe some interesting features there too.)

Double-click on the cell with the formula and the range is selected. And movement will start in the first reference, then follow the order in the formula.

It will even open other spreadsheets and load the range.

It will not go to a cell twice. So listing a cell a second time, even if not directly but inside a range referece, say, will not get you there twice.

You can build the formula rather than write it by clicking the cells one by one, typing a comma between each, until done.

It uses whatever your similar delimiter is, so in Euroland, for example, broadly a semi-colon between references, not a comma.

It's great if you want to follow an ordser through cells, or if you want to leap away from where you were, but end up back there when finished with a string of entries, or simply looking at each cell content.

Excel used to have a limitation that I believe was a Windows problem at its root in that if you gave it a range like the above formula, it would actually start in the last cell show (F11 in the above) as if it were the first. Windows did a similarr thing in that selecting, say, three files to do something to/with/whatever, it took the last one first, then the rest in order. Excel fixed that some years back, but there might be older versions in use that still see it. And if my equating the two things is on target, maybe it was that Windows fixed it, and in that case, even a modern Excel version might still see it happen if using an older Windows version. If it does, simply list the desired starting reference last...

If you give such a listing of references an appropriately Named Range, you can actually wander as you'd like, then type, say, "=EntryForm" into some cell you're near that is conveniently empty, or even add a worksheet and enter it (so cleanup after your session isn't hunting for those cells you used over the last two hours, but just deleting your scratch page), then double-click it and bang, you're back at the data entry form. Or whatever the range was.

Good, by the way, if yourr boss set data up to be entered in some order that made sense to him, but ain't really good for you. Just set it up so the order of cells matches YOUR workflow and you don't need Bob as your uncle.