Sometimes filling a sheet full of data can be slow and painful. It’s the navigating between cells that slows me down.
You know how it goes, type the First Name, (arrow right), (arrow right), (arrow right), type the Last Name, (arrow down), (arrow left), (arrow left), (arrow left), type the Occupation, etc…
Maybe you’ve resorted to using the mouse for field navigation.
Maybe you’ve even set up sheet protection so the cursor automatically moves between unlocked cells.
Here is another way.
If you have a bunch of cells selected, you can press Enter (or Tab!) to move between them (it cycles through them).
The trick is in the order that you select them.
So if you have 5 cells:
Click Cell 2
While holding down the Ctrl key click Cell 3, Cell 4, Cell 5 then Cell 1
If you want to save that selection for later, make it a Named Range. Excel remembers the order you clicked and saves that as part of the Name.