How To Create A Form In A Spreadsheet With Pictures

Click File. Click Options in the bottom-left side of the window. Click Quick Access Toolbar on the left side of the window. Click the “Choose commands from” drop-down box at the top of the window. Click All Commands. Scroll down until you reach Form, then click it. Click Add » in the middle of the window. Click OK.

For example, if you’re creating a form that lists different baked items, you might type “Pumpkin Bread” into cell A1, “Muffins” into cell B1, and so on.

Windows — Click File, click Options, click Customize Ribbon, check the “Developer” box, and click OK. Mac — Click Excel, click Preferences. . . , click Authoring under the “View” heading, and click Developer tab. You can then close the window.

Windows — Click File, click Options, click Customize Ribbon, check the “Developer” box, and click OK. Mac — Click Excel, click Preferences. . . , click Authoring under the “View” heading, and click Developer tab. You can then close the window.

This step will vary depending on the information you want to use in your form.

Skip this step on a Mac.

Skip this step on a Mac.

For example, if you want to add a checkbox to your form, you would click the checkbox icon.

You can click and drag your control to the location in which you want to anchor it.

On a Mac, hold down Control while clicking the icon.

For example, if you wanted to create a drop-down menu with a list of numbers, you would click the arrow to the right of the “Cell range” text box and then click and drag your mouse down a column of numbers in your spreadsheet.

At this point, you can proceed with adding other form buttons to your spreadsheet.

Windows — Click Review in the Excel toolbar, click Protect Sheet, make sure that any options other than “Select locked cells” and “Select unlocked cells” are unchecked, enter a password to unlock the document, and click OK. You can then re-enter the password when prompted to finish locking the sheet. Mac — Click Tools at the top of the screen, select Protection, click Protect Sheet in the pop-out menu, make sure that any options other than “Select locked cells” and “Select unlocked cells” are unchecked, enter a password to unlock the document, and click OK. You can then re-enter the password when prompted to finish locking the sheet.