Forum Discussion
Jump to specific cell after pressing enter
Hi all, Is there a way to force Excel to jump to a specific cell after pressing enter? I have 2 columns of data that I'd like to alterate between quickly, i.e. A2, then D2, then A3, then D3, ...
Thank you.
This works great for Tab. Is there a way to make this do the same when pressing Enter? Still goes down when I do that.
Mike
This works great for Tab. Is there a way to make this do the same when pressing Enter? Still goes down when I do that.
Mike
You'd have to do two things:
1) When you protect the sheet, clear the check box "Select locked cells" and leave only "Select unlocked cells" ticked:
2) Select File > Options.
Select Advanced.
Under 'After pressing Enter, move selection', select Right from the Direction dropdown.
Then click OK.