- Jul 26, 2012
Hi, im creating a form for people to complete in excel. I need to have a 'full' and 'simplified' version of the form.. The default view would be the simplified version, which would include some rows of superfluous data to be hidden. One of the fields will be a drop down list with 'yes/no' options- is there a way to unhide the additional fields if 'yes' is selected and to have them hidden if 'no' or (no value) is chosen?