Forum Discussion
Setting the TAB order in an Excel document
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
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
Thank you so much Branka, I'll try that. 🙂
Would you by chance know if this document will work in older versions of Excel if I do the table?
The forms I create are used by folks who are using all different versions of Excel so I need to either make the one form work in as many versions as possible, or make more than one version. 🙂
Thank you again, Branka!!
Diane