Others

How to Create an Excel Database List and Data Entry Form

Kushani Nimanthika Oct 21, 2026 868 views

Question details

The user wants to create a database list in Excel and use a data entry form to manage records, but the Form command is missing from the Ribbon in newer versions.

How to Create a Database List and Data Entry Form in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a structured database and facilitating fast data entry using Excel's built-in form tool.
Observed behavior: The user needs to set up a data table and locate the hidden Form command to easily enter, search, edit, sort, and filter records.

Before you start

Ensure your data is organized with clear column headers in the first row and that there are no blank rows or columns within your dataset.

Solution 1Recommended

Format Data as a Table and Add the Form Command

Convert your data into an official Excel table and add the hidden Form tool to the Quick Access Toolbar for seamless data entry.

In newer versions of Excel, the data entry form is still available but hidden by default. By formatting your data as a table and adding the Form command to your Quick Access Toolbar (QAT), you can quickly input, search, and manage your records without navigating through complex menus.

Set up your column headers

Enter your field names (column headers) in the first row of your worksheet and add at least one record of data directly below them.

Format the range as a Table

Click inside your data range, go to the 'Insert' tab on the Ribbon, and select 'Table'. Ensure that the 'My table has headers' box is checked, then click 'OK'.

Open the Quick Access Toolbar settings

Click the drop-down arrow at the top-left of the Excel window (on the Quick Access Toolbar) and select 'More Commands...' to open the Excel Options dialog.

Add the Form command

In the 'Choose commands from' drop-down menu, select 'Commands Not in the Ribbon'. Scroll down the alphabetical list to find 'Form...', click on it, click the 'Add >>' button in the middle, and then hit 'OK'.

Use the Data Form

Click any cell inside your newly created table, then click the new 'Form' icon on your Quick Access Toolbar to open the dialog box and start managing your records.

Format Data as a Table and Add the Form Command

Cannot Find the Command?: If you cannot find 'Form' in the list, double-check that you have selected 'Commands Not in the Ribbon' or 'All Commands' from the drop-down menu, rather than 'Popular Commands'.

Efficient Data Management

Create Data Entry Forms Instantly in WPS Spreadsheet

WPS Spreadsheet provides an intuitive and accessible way to manage your database lists. The Form tool is readily available on the main ribbon, allowing you to quickly input, edit, and search records without digging through hidden settings or customizing toolbars.

1. Open your dataset in WPS: Launch WPS Spreadsheet and open your existing data file, or start a new sheet and type your column headers in the first row.
2. Select your data range: Click on any cell containing your data or headers to make it the active cell.
3. Launch the Data Form: Navigate to the 'Data' tab on the top ribbon and click the 'Form' button. A data entry dialog will appear instantly, allowing you to add, edit, or search records.

Built-in Data Form tool is easily accessible directly from the Data tab.Fully compatible with Microsoft Excel (.xlsx, .xls) files and database formats.Lightweight, fast, and highly efficient for processing large datasets.Familiar interface ensures no learning curve for Excel users.

Frequently Asked Questions

Why is the Form command missing from my Excel Ribbon?

In modern versions of Excel, Microsoft removed the Form command from the default Ribbon to streamline the interface. However, the feature was not deleted; it simply needs to be manually added to the Quick Access Toolbar via the 'Commands Not in the Ribbon' menu.

Can I use the data entry form without creating a table first?

Yes, you can use the Form tool on a standard range of data as long as it has clear column headers. However, formatting it as an official Excel Table (Insert > Table) is highly recommended because it ensures new records added via the form are automatically included in the dataset and formatting.

How do I search for specific records using the Excel Data Form?

To search for records, open the Data Form and click the 'Criteria' button. The fields will clear, allowing you to enter your specific search terms (like a specific name or ID). Once entered, use the 'Find Prev' or 'Find Next' buttons to jump to the matching records.

Office Quick Solutions