There are some pretty geeky ways to create forms in Microsoft Office. Start with these less geeky solutions first. Word The easiest way to begin is to create a table with one column for your field descriptions and another for the user to enter data. To keep the users in their “dance space,” protect the document with Restrict Editing, and open up only the empty cells meant for data entry. On the Review tab, Protect group, click Restrict Editing.

In the task pane on the right, click the box next to “Allow only this type of editing in the document.” A new section will pop up called Exceptions (optional). First, select the column of empty cells for user input so that they are all shaded, then click the checkbox next to “Everyone.” Finish by clicking the button marked “Yes, Start Enforcing Protection.” You’ll be offered the oppor­­tunity to create a password to allow you to unrestrict editing for this document. You’ll notice that you can click in the cells to the right of your field descriptions but not on them.

The procedure is similar in Mac Excel 2011. If you are using Mac Excel 2016, Microsoft has removed almost all features from the VBA Editor. Microsoft rebuilt Office to use Apple’s latest frameworks, but ran out of time before the VBA Editor was finished. Until they fill the gap, you should either build your code in Mac Excel 2011 or in. In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the 'Form' option on the Data menu. There's a separate suggestion on UserVoice for that.

Don’t like the boxy look of a table? Use only bottom borders instead of all borders to format your table. Outlook Many people don’t know that they can save an email template. For example, if you often send out the same rich text or html email or one with attachments, you can click on File, Save As, and in the “Save as type” field, choose Outlook Template.

Well I think Scrivener is good because it gives people the option to write out of order. Where something like Google Docs or Microsoft Word, you have one page and you have no choice but to write linearly. Compare Google Docs vs Scrivener. Comparison of Google Docs vs. Based on data from user reviews. Google Docs rates 4.7/5 stars with 2,562 reviews. Scrivener rates 4.7/5 stars with 48 reviews. Each product's score is calculated by real-time data from verified user reviews.

It will be stored in a place that is accessible when you click on the New Items button and choose More items, Choose form, then User Templates in System from the “Look in” field. But, you’re trying to create a form. You can create a table in an email by clicking into the body of the email and then on the Insert tab in the ribbon. Click the table button, and create your form. It might be easier to start in Excel where you have more formatting freedom. Then you can copy/paste it back to an open email before saving it as a template. You don’t necessarily have the same ability using this method to protect the actual form itself.

Excel In Excel, try hiding gridlines (View tab, Show group, Gridlines checkbox). Then use borders to define field descriptions and fillable cells. To make Excel function like a form, select the cells that you want users to type in. Press Ctrl+1 to activate the Format Cells dialog box.

Click on the Protection tab in the dialog box, and uncheck the Locked check box. Finish by clicking the Review tab, and in the Changes group, click on Protect Sheet. Uncheck Select Locked Cells, and give it a password (optional). Now your form can only be filled from the fields you unlocked.