Setting the TAB order in an Excel document

Question

Hi All!!&nbsp;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.&nbsp;On the right side of the document I need the user to be able to TAB through the first row filling in each field, then TAB down to the next row to fill in each field, then TAB down to the next row to fill it in, and so on.&nbsp;Currently it doesn't drop to the 2nd row when it gets to the end of the 1st row, it just TABS right back into the 1st field in the first row.&nbsp;Thank you so much to everyone that comes in here to help!!Diane

branka bradule · Answer

DianeDennis&nbsp;&nbsp;have you tried to format your form as a table?

dianedennis · Answer

Branka Bradule&nbsp;Hi!&nbsp;Thank you for responding! 🙂&nbsp;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.&nbsp;Any ideas?&nbsp;Thank you again so much!!Diane

branka bradule · Answer

DianeDennis&nbsp;Could you share the output of the latest actions?&nbsp;Thanks,Branka

dianedennis · Answer

Branka Bradule&nbsp;Hi!&nbsp;Absolutely, thank you! 🙂 Here you go. 🙂&nbsp;Diane

branka bradule · Answer

DianeDennis&nbsp;&nbsp;Hi!&nbsp;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.&nbsp;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).&nbsp;Could this solution work for your example?&nbsp;Best,Branka

Forum Discussion

Setting the TAB order in an Excel document

6 Replies

Resources