Show Or Hide From Column. On the Format menu click Cells and then click the Protection tab. Locate the Properties section.
Go to the list or library for which you want to show or hide columns in the form. You can replace the column name A in lines 3 6 and 9 with the name of the column you want to hide. Similarly we want to hide column B when cell E2 contains the value F.
Add a button to the first page pointing to the 2nd bookmark.
On the Format menu click Cells and then click the Protection tab. Its possible to conceal some columns by using the Hide feature or by setting the column width to zero. You can hide the column or hide the formula if applicable in the column. You can show or hide columns in a list form based on another columns value by specifying a formula that are equations performing conditional checks on values in a SharePoint list or library.