If a simple form like the one demonstrated above is all that you are after, then you don't need to read on. In the Restrict Formatting and Editing pane that appears, apply protection for Filling in forms and then start enforcing protection. To apply editing restrictions to the form, click Developer>Protect>Restrict Editing. I'll demonstrate the other methods and explain "albeit practically useless" later in the discussion.
This method is already familiar to users moving from legacy forms and it offers, the albeit practically useless, password protection. Unfortunately, as with legacy forms, there is no perfect, ideal method and each has its advantages and disadvantages.įor our basic form, I will use traditional document editing restrictions - Filling in forms. There are a couple of ways that you can do this with content control forms.
This Microsoft Word Help & Tips page will show you how to create a functional content control form "similar" to the insurance application form example that Dian uses in part 2 of her legacy form series.īasic form with fill-in plain text and checkbox content controls Restrict Editing - Filling in formsĪs with any form, a Word content control form is supposed to maintain "form." You want the form user to input information is the spaces provided, and not be able to alter other content or your form layout.
While the legacy form fields are still available through Word 2013, and several long standing content control shortcomings remain in my opinion, content controls stand poised to relegate "legacy" form fields to the dust bin of history. Note: I have a summary and a steadily growing collection of subject articles on content controls beginning here: Content Controls. Content controls continue to evolve and have been steadily expanded and enhanced as each new Office suite version is released. Microsoft introduced content controls with the release of Word 2007. Chapman explaining their design and use beginning here: Please Fill Out This Form.
There is an excellent 5 part series of articles by Dian D. Word forms using "legacy" form fields have been around since at least Word 97. call them what you will like their predecessor, the printed page with lines, Microsoft Word forms provide a structured and convenient means for the document user to input information. To learn that jump to the last paragraph (Conclusion part) of this tutorial.Online forms, protected forms, fill-in forms, electronic "e" forms.
I mean, you can apply the upper, lower, proper, or sentence case in the same cell where the original text is. It is because we are using functions to convert text case in Google Sheets.īut don’t worry! We can later replace the existing text with the converted one. It will change the text form (text case), but you will get the result in a new cell.įor example, the text in cell C6 can be converted in cell D6 or any other cell (see the screenshot) not in cell C6 itself. You can first apply the formulas on any spreadsheet cell to get the result. Open a spreadsheet and just read and apply the points (formulas) under the subtitles given below. How to Change Text to Upper, Lower, Proper Case in Google Sheets I hope this post will be helpful to them. Many users know how to change the text case in Document Editors but not in Spreadsheets. I have a custom formula for sentence case, that formula use is not applicable in Excel. This post is written keeping in mind both Excel and Google Sheets users except at one point. Let’s learn how to change text case to upper, lower, proper, or sentence case in Google Sheets.Īs you may already know, I have a separate section on Info Inspired that completely dedicated to Google Doc Spreadsheet Tutorials and Excel Vs Sheets formulas.