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, ...
If you unlock columns A and D and then protect the sheet, allowing only unprotected cells to be selected, then 'tab' will alternate between the two columns. Whether that creates more problems than it solves is for you to decide.
Sorry Hans. For some reason your answers didn't show.