How do i make an Excel document fillable and not editable

I export excel in protected or using password manner and there is a chance to unprotect the sheet. I want that, there is no option to edit after export the excel in vb.net.

Table of Contents Show

1 Create the Form
2 Prevent Editing
How do you turn an Excel sheet into a fillable form?
How do you make an Excel file non editable?
How do you create fillable cells in Excel?
How do you make a sheet not editable?

asked Feb 18, 2020 at 5:46

To make a column non-editable:

Select the whole worksheet, Right Click->Format Cells->Protection, uncheck the "Locked" check box.
Select the column you want to protect, right Click->Format Cells->Protection, select the "Locked" check box.
Review tab->Protect Sheet, select the "Protect worksheet and contents of locked cells" check box and protect the sheet using a password.

answered Feb 18, 2020 at 6:15

One benefit of using Microsoft Word as your business's word-processing application is that you can create forms that are both protected and fillable. Adding the Developer tab to the ribbon enables you to use controls that allow users to mark check boxes, select dates, choose options from drop-down lists and more. When you have completed the form, you can add protection to it, which will prevent those filling the forms from making any changes to the base document.

Step 1

Add the Developer tab. Select the "File" tab, click "Options" and choose "Customize Ribbon." Select the "Developer" check box in the Customize the Ribbon list under Main Tabs and click "OK."

Step 2

Add content controls. Open a template or a new, blank document and select the "Developer" tab. Click on the document where you want to add a text box, check box or other control and click the type of control you want to add in the Controls group.

Step 3

Add properties to the control. Click on the content control and select "Properties" in the Controls group of the Developer tab to open the Content Control Properties dialog box. Customize the control and click "OK."

Step 4

Add instructional text if you want to provide instructions, tips or other information for the control. Click "Design Mode" in the Controls group on the Developer tab. Click on the content control and type your instructional text over the example text. Make sure "Contents Cannot Be Edited" is not selected in the controls properties, or users will not be able to type over the instructional text.

Step 5

Protect the document so it is not editable. Press "Ctrl-A" to select the entire document, or click "Select" in the Editing group of the Home tab and choose "Select All." Select the "Developer" tab and click "Restrict Editing" in the Protect group. Save the document before closing it.

References

Warnings

Information in this article applies to Word 2013. It may vary slightly or significantly with other versions or products

Writer Bio

Tricia Goss' credits include Fitness Plus, Good News Tucson and Layover Magazine. She is certified in Microsoft application and served as the newsletter editor for OfficeUsers.org. She has also contributed to The Dollar Stretcher, Life Tips and Childcare Magazine.

Image Credit

Ryan McVay/Photodisc/Getty Images

... Jupiterimages/Stockbyte/Getty Images

You can create forms using Microsoft Word that can be completed electronically and returned to you -- especially helpful if you have an assignment that requires peer surveys or group collaboration. When you also password-protect the document, you can limit or restrict the user's editing capabilities so they can only fill out the form and enter new content where you permit.

Explore this article

1 Create the Form

Click the "File" tab and select "Options," then click "Customize Ribbon." Select the "Developer" check box in the list under Main Tabs and then click "OK." From there, use an existing form template or create a new form on a blank document (see "Create a Fillable Form" in Resources). You can control the content entered with tools like check boxes, text boxes, date selectors and drop-down lists. For more complex formatting, you can even use formulas and links as you would when designing a database.

2 Prevent Editing

When your form has been designed and you are happy with the results, you can add protection so that editing is restricted. Click "Home," and then choose "Select" and "Select All." Alternatively, you can press "Ctrl-A" to select all content. Click "Developer," and then select "Restrict Editing."

About the Author

Based in Tampa, Fla., Danielle Fernandez been writing, editing and illustrating all things technology, lifestyle and education since 1999. Her work has appeared in the Tampa Tribune, Working Mother magazine, and a variety of technical publications, including BICSI's "Telecommunications Distribution Methods Manual." Fernandez holds a bachelor's degree in English from the University of South Florida.

How do you turn an Excel sheet into a fillable form?

Create forms that users complete or print in Excel.

Step 1: Show the Developer tab. On the Excel menu, click Preferences. ... .

Step 2: Add and format content controls. On the Developer tab, click the control that you want to add. ... .

Step 3: Protect the sheet that contains the form. ... .

Step 4: Test the form (optional).

How do you make an Excel file non editable?

On the worksheet, select just the cells that you want to lock. Bring up the Format Cells popup window again (Ctrl+Shift+F). This time, on the Protection tab, check the Locked box and then click OK. On the Review tab, click Protect Sheet.