Forum Discussion

Valentino54's avatar
Valentino54
Copper Contributor
Nov 14, 2021

Tabulating sequence

Hi friends, I'm new to this group and would be glad if someone could help me.

 

I designed a simple form on a blocked sheet with a few free cells, to be completed jumping from one cell to another with the the TAB key. But TAB is not following a regular progression on the worksheet. It jumps randomly from one cell to another.

 

Is there any way to determine the sequence of the flow of cells with the TAB key, similarly to the Access application?

 

Attached the spreadsheet, already protected, but with no password.

 

Many thanks for eventual help in advance.

 

Valentino

excel

2 Replies

  • bosinander's avatar
    bosinander
    Iron Contributor
    Nov 14, 2021

    Valentino54 

    Hi. Unprotected cells are jumped to from left to right and then downwards. Shift+tab to reverse direction.
    Assuming you do not want to change your layout, you may define a name with the intended tab order;
    Select the input cells in the wanted order - you need to press control key while selecting them.

    Give the selection a name, eg input by typing in in the Name Box and press enter.

     

    Saving the file with that selection makes it easy to type and tab in the wanted order.

    If the user changes the selection, which is easily done, it can be restored using the menu in the name box.

    Use tab key ta have the wanted start cell active in the selection when you define the name and when you save the file.

Resources