Home

HELP NEEDED!!! Jump to new column

Ryan Lange
Occasional Contributor

I have a fairly easy spreadsheet to track my inventory but I need some help with something that should be simple...

 

I would like to end my entries after B37 and start them have it automatically take me back to L13 to start my new entries.

 

Is this possible?

 

 

1 Reply

Hi Ryan,

 

the easiest way would be to untick 'Locked' box in Format Cells/Protection/ for all input cells, then protect sheet with 'Select Locked Cells' unticked. The result of hitting 'Enter' in the last unlocked cell of each column would be that the cursor jumps to the first unlocked cell of the next column. If 'Enter' is hit on cell J37, the cursor would jump to L13. Please see the attached file for your reference.

 

Hope this helps

Yury