Forum Discussion

DianeDennis's avatar
DianeDennis
Brass Contributor
Feb 01, 2021

Setting the TAB order in an Excel document

Hi All!!   I've created a fillable form in Excel and I need to be able to set the TAB order from fill-in field to fill-in field.   On the right side of the document I need the user to be able to ...
excel
office 365
DianeDennis's avatar
DianeDennis
Brass Contributor
Feb 02, 2021

Branka Bradule 

Hi!

 

Thank you for responding! 🙂

 

I had not tried that, so I did just now. It threw a row into the top of the section that numbered each column, and it increased the size of the form so that it's on two pages.

 

Any ideas?

 

Thank you again so much!!

Diane

  • Branka Bradule's avatar
    Branka Bradule
    Brass Contributor
    Feb 02, 2021

    DianeDennis 

    Could you share the output of the latest actions?

     

    Thanks,

    Branka

      • Branka Bradule's avatar
        Branka Bradule
        Brass Contributor
        Feb 02, 2021

        DianeDennis 

         

        Hi!

         

        If you format your data as a table, Excel will demand the header row and that's why it was added to your current data. If we rename the generic headings, push them to be in the position of the previous headings, and format their orientation, it could look like in the attached example.

         

        Here you will see that the content is now on one sheet, which was accomplished by navigating to the Page Break Preview (on the right side of the status bar below - marked with number 1 on the picture below) and then by dragging the breaking point to the right side (2).

         

        Could this solution work for your example?

         

        Best,

        Branka

Resources