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


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies