Hide The Q1-Q2 Worksheet - Apply the preset 10 picture effect to the. To unhide worksheets, follow the same steps, but select unhide. Click the formulas tab and click insert function. On the q1 sales worksheet, select cell b4. Web hi i have to create a questionnare in excel in which if a user answers n to q1, then only q2 should be made visible, else q2 is hidden. Close the checker when the check is complete. Web on the home tab, in the cells group, click format > visibility > hide & unhide > hide sheet. In the search for a function field, type the keyword, join and then click go.
Web on the home tab, in the cells group, click format > visibility > hide & unhide > hide sheet. Close the checker when the check is complete. Apply the preset 10 picture effect to the. To unhide worksheets, follow the same steps, but select unhide. Web hi i have to create a questionnare in excel in which if a user answers n to q1, then only q2 should be made visible, else q2 is hidden. Click the formulas tab and click insert function. In the search for a function field, type the keyword, join and then click go. On the q1 sales worksheet, select cell b4.