When I create a document out of Excel, let's say I have 10 lines. Each line has a "Yes" "No" and "N/A" option. When I click on prepare form it places text boxes in those three slots instead of radio boxes.
My question is, what can I do in Excel prior to exporting my document to PDF, so when I click the Prepare Form option, the software understands these need to be Radio boxes instead of Text boxes. In addition, it needs to group each line individually. So if I have 10 lines, it would create 10 groups, and each group will have 3 options of "Yes" "No" and "N/A".
Please let me know how I can achieve this as this can impact me and my team greatly and increase the productivity of the whole group.