Forum Discussion

bg425gk's avatar
bg425gk
Copper Contributor
Oct 01, 2025

Movement in spreadsheet as form after enter

When using an Excel spreadsheet as a form, is there a way to move from one cell location directly to another cell location after pressing enter in the first cell?

What I want to do is have the user enter the width in cell B7, hit enter, and have B9 become the "active" cell, then enter the length in B9, hit enter, and have B11 become the "active" cell, so on and so forth. Essentially I want to skip from one input cell to another without having to go through all of the rows.

Not all "moves" from one cell to another would be exactly two rows down, other locations in the spreadsheet would require moves of 3 or 4 rows to get to the next "active" cell. All of my moves would be in the same column though.

 

Thanks to all who look at this.

1 Reply

  • mathetes's avatar
    mathetes
    Silver Contributor

    I could be wrong about this--not having done this in a llloonnnggg time, but if my memory serves, if you protect the sheet, but specify the cells in question as "unprotected," then the kind of movement you're suggesting happens "automatically," since those are the only cells the user is permitted to use.

Resources