Catalog

2 Easy Ways to Create a Fillable Form in Excel

November 14, 2023 2.0K views

You may need to create forms for your surveys, online orders, job application forms, and more. However, you may need clarification about the steps and easy methods for creating a fillable form in Excel. What are some easy ways to make a fillable form in Excel? How does it go? This article will provide you with a complete guide on how to create a fillable form in Excel.

How to Make a Fillable Data Entry Form in a Spreadsheet

We will learn how to create a form in spreadsheet based on three methods.

1. Creating a Fillable Data Entry Form in Excel

Step 1: In an Excel file, type in the headings as shown below.

Type in the headings

Step 2: Choose the heading row and convert it into a table as shown below.

Click Insert>Table, then Ok

Click Insert>Table, then Ok

Step 3: Move to the file tab.

Move to the File tab

Step 4: Click on the options as shown.

Click Options tab

Step 5: Select Customized Ribbon, Insert, Then New group, and click Rename.

Give your group name as shown below. Here, we have ‘Insert Name’ and then hit OK.

Click customized ribbon> then insert> New group> Rename> Give new name on display name part,>then Ok

Click customized ribbon> then insert> New group> Rename> Give new name on display name part,>then Ok

Step 6: Select Command Not in the Ribbon in the Choose Command section.

Choose Form, then Add, followed by Insert Form. Click Ok.

 Select Command Not in Ribbon>Choose command section, Choose Form, then Add, followed by Insert Form. Click Ok.

Select Command Not in Ribbon>Choose command section, Choose Form, then Add, followed by Insert Form. Click Ok.

Step 7: Choose the header row and move to Insert, then Form.

Step 8: A dialogue box, as shown below, will appear. Include the relevant data, i.e., Employee data, and click New. That is how you add employee data.

Click New

Step 9: Add another data and again click on New.

Click New to add another data

Step 10: After this, another data appears below the first. As shown below.

Data appears on the table

2. Making Fillable Forms from Available Templates Excel

WPS Office provides a valuable resource of free Excel templates with fillable forms, offering users efficiency, convenience, and customization options for various business and personal tasks.

Users can access templates like;

  • Company Sales Statement: For recording sales data.

Cash flow statement

  • Simple delivery templates allow calculating all accounting details via automatic spreadsheet formulas.

Simple delivery templates

Simple delivery templates

  • Product inspection checklist: This checklist is fully edited and available online for free.

Product Inspection Checklist

Product Inspection Checklist

3. Apply data validation to cells

Video link

https://www.microsoft.com/en-us/videoplayer/embed/RWfvNp?pid=ocpVideo1-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&reporting=true&market=en-us

Step 1: Choose the cells you want to create a rule for.

Step 2: Click on Data, then followed by Data Validation.

Step 3: In the Data Validation dialog box, go to the Settings tab.

Step 4: Under the "Allow" section, select the type of data validation you want to apply:

  - Whole Number: Allows only whole numbers.

  - Decimal: Allows only decimal numbers.

  - List: Creates a drop-down list for users to select from.

  - Date: Accepts only date values.

  - Time: Accepts only time values.

  - Text Length: Sets a limit on the length of the text.

  - Custom: Allows you to create a custom formula for data validation.

Step 5: Based on the selection in the previous step, adjust the required values under the "Data" section.

Step 6: Move to the Input Message tab and customize a message users will see when entering data.

Step 7: Check the "Show input message when the cell is selected" checkbox to display the message when the user interacts with the cell(s).

Step 8: Switch to the Error Alert tab to customize the error message when an invalid value is entered, and choose an appropriate error style.

Step 9: Click OK to apply the data validation.

Here's a brief overview of the differences between the three methods

  1. Creating a Fillable Data Entry Form in Excel:

Quickness: It involves creating a custom data entry form in Excel, which may take some time, especially for beginners.

Simplicity: This method might be a bit more complex for beginners due to the multiple steps involved

  1. Making Fillable Form from Available Templates of Excel:

Quickness: This is the quickest method involving pre-designed templates with fillable forms.

Simplicity: This method is straightforward and user-friendly, especially for beginners, as it eliminates the need for complex setup or customization.

  1. Apply Data Validation to Cells:

Quickness: The speed of this method depends on the complexity of the data validation rules you want to apply.

Simplicity: This method can be straightforward for basic data validation but may become more complex when creating custom validation rules.

Recommendation Based on my Experience:

The "Making Fillable Form from Available Templates of Excel" method is recommended for beginners or those looking for a quick and straightforward solution. It's efficient, user-friendly, and provides access to ready-made templates, saving you time and effort.

If you require more customization and have some familiarity with Excel, you can explore the "Apply Data Validation to Cells" method. It offers flexibility but may involve a learning curve for those new to Excel.

The "Creating a Fillable Data Entry Form in Excel" method is best suited for users with specific customization needs and willing to invest time in setting up a custom data entry form in Excel.

Best Alternative to Make a Printable Form——WPS Office

WPS is a powerful office software with stable operation and fashionable design.

It can perform tasks such as;

  • Text processing,

  • Table production,

  • Slide production,

  • Graphic image processing,

  • Simple database processing.

My personal experience with WPS Office has been great. WPS Office offers a free standard for a versatile suite of office applications. It's compatible with various platforms and offers cost-effective premium and business plans.

It offers almost all services present in Microsoft Office but with the added advantage of effective costing.

WPS Office is more suitable for individuals, students, and small businesses looking for a cost-effective office solution with essential features.

How to download WPS Office for free?

Let’s learn the steps right away;

Step 1: Select a browser and access the WPS Office Official Site.

WPS Office site

WPS Office site

Step 2: Press on ‘Get store app’

 Press ‘Get store app’

Press ‘Get store app’

Step 3: Click on ‘Open Microsoft store’

Select ‘Open Microsoft store.’

Select ‘Open Microsoft store.’

Step 4: Press ‘Get’ to download the software.

Click on ‘Get’

Click on ‘Get’

Step 5: Downloading begins right away.

Download taking place

Download taking place

Step 6: Press on ‘Open’ to access the software.

 Click Open

Click Open

Step 7: Press ‘Agree and continue’ into the software interface.

Click ‘Agree and Continue

Click ‘Agree and Continue

Step 8: You can now access the software for documents, spreadsheets, PowerPoint, and more.

You can access to all files now

You can access to all files now

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

FAQs

How do I create a fillable PDF from Excel?

To create a fillable PDF from an Excel spreadsheet, you can follow these steps;

Step 1: Convert Excel Spreadsheet to PDF:

  • Open your Excel file.

  • Click "File" and then select "Save As" or "Print."

  • In the "Save As" dialog, choose the option to save as a PDF. You can find this option in the dropdown list of file formats.

  • Alternatively, you can create a PDF by using the Foxit Add-in in Microsoft Excel.

Step 2: Recognition of the Form Fields:

  • Open the PDF document you've converted from the Excel spreadsheet in Foxit PDF Editor.

  • Navigate to the "Form" menu within Foxit PDF Editor.

  • Select "Run Form Field Recognition." This step will identify the areas in the PDF where form fields should be created.

  • You can further edit or customize the recognized form fields as needed.

How do I create an automated form in Excel?

Step 1: Open the Excel file for the data you want to work with.

Step 2: Locate the Quick Access Toolbar at the top of the Excel window (usually below the ribbon).

Step 3: In the drop-down menu, select More commands.

Step 4: In the dialog box, under "Choose commands from," select "All Commands." That will display a list of all available Excel commands.

Step 5: Select "Form" and click the "Add>>" button to add it to the Quick Access Toolbar, and then OK.

Step 6: Return to your datasheet and select all the data you want to work with. You can do this by clicking and dragging to select a range or pressing "Ctrl + A" to select the entire sheet.

Step 7: Once your data is selected, click the "Form" button on your Quick Access Toolbar.

The Excel data entry form will be presented to you. This form allows you to:

  • Enter new data.

  • Edit existing data.

  • Delete data.

  • Search for specific data using criteria.

Step 8: After adding the "Form" command to your Quick Access Toolbar, you can access it whenever you work with large data sheets in Excel.

Summary

The guide offers a comprehensive guide on creating a data form in Excel. It highlights the user-friendly nature of making Form from Available Templates of Excel, its simplicity and efficiency, making it a recommended choice, especially for beginners. Be sure to consider WPS Office. It is a cost-effective alternative to Microsoft Office, suitable for individuals and small businesses, citing its rich features and stability.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.