You must turn off worksheet protection when you want to build a form.

Turning off sheet protection enables you to use the form controls on the Developer tab of the Ribbon and allows you to edit worksheet content.

When youre done building the form, you must turn on protection so that people can tab through the input fields.

You unlock cells that you want to designate as input fields, which are the cells that users fill in.

You also unlock the cells that will have the result of a choice made by a user in a form control.

When you want to create or edit a form, you need to make sure the worksheet is unprotected; if its protected, you cant edit the form.

Conversely, when youre ready to test or use your form, you must turn on protection.

The Protect Sheet button has become an Unprotect Sheet button.

While protection is turned on, pressing the Tab key takes the cursor from one input field (unlocked cell) to the next.

Your worksheet is enabled for editing, and the Unprotect button reverts to the Protect Sheet button.

Click the Protection tab in the Format Cells dialog and then deselect the Locked option.

If you installed the MVP Toolbar, you can simply click the LockUnlock Cell toggle button on the toolbar.

On the MVP Toolbar, the Lock Cell button acts as status indicator.

When it appears as a depressed button, the selected cell(s) is (are) locked.

It always indicates the lock state of the current selection.

How Do You Protect Cells In Excel Professional Presentations And

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

For Mac How Do You Protect Cells In Excel