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, ...
You might do the following:
- Press F5.
- Enter A2:A100,D2:D100 and press Enter or click OK.
- Press Ctrl+1 to activate the Format Cells dialog.
- Activate the Protection tab.
- Clear the Locked check box, then click OK.
- Activate the Review tab of the ribbon.
- Click Protect Sheet, then click OK.
- Tab will now do what you want.
- If you want to edit other cells, click Unprotect Sheet on the Review tab of the ribbon.
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.