How to Remove the Data Entry Form Button in Excel
Question details
The user needs to remove the Excel Data Entry Form button from the Quick Access Toolbar after already removing it from the Ribbon.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Customizing the Excel workspace by cleaning up unused commands from the Quick Access Toolbar.
- Observed behavior
- The Data Entry Form command remains visible on the Quick Access Toolbar even after being removed from the Ribbon, requiring a separate removal step.
Verify that you no longer need the quick shortcut for the Data Entry Form. Rest assured that hiding this button will not delete or alter any existing data or macros in your workbook.
Remove the Form Button via Right-Click Menu
The fastest and most direct method to remove the Data Entry Form button from the Quick Access Toolbar.
Since the Ribbon and the Quick Access Toolbar are managed independently in Excel, commands added to both must be removed from both. You can quickly remove the remaining shortcut using the context menu.
Find the Quick Access Toolbar at the top-left corner of your Excel window, typically located just above or below the Ribbon.
Hover your mouse over the Data Entry Form icon on the toolbar and right-click on it to open the context menu.
Click on 'Remove from Quick Access Toolbar' from the drop-down list. The button will immediately disappear from the toolbar.

Remove the Form Button via Excel Options
An alternative method useful for customizing multiple Quick Access Toolbar commands simultaneously.
Customize Your Toolbar Easily in WPS Spreadsheet
WPS Spreadsheet provides a highly intuitive and customizable interface, allowing you to easily add or remove data entry forms and other productivity tools from your Quick Access Toolbar. Enjoy a smooth workflow with a lightweight, free office suite.
- 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
- 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and locate the Quick Access Toolbar at the top left of the application window.
- 3. Customize the Toolbar: Right-click any unwanted icon, such as a Form button, and simply select 'Remove from Quick Access Toolbar' to clean up your workspace.

Frequently Asked Questions
Will removing the Form button delete my Excel data?
No. Removing the Form button from the Quick Access Toolbar or Ribbon only deletes the visual shortcut. Your actual worksheet data, VBA code, and any manually created user forms remain completely intact and unaffected.
How do I add the Data Entry Form button back if I need it later?
You can restore the button by navigating to File > Options > Quick Access Toolbar. In the 'Choose commands from' drop-down, select 'Commands Not in the Ribbon' or 'All Commands', find 'Form...', click the 'Add' button, and then click 'OK'.
Why is the Form button still visible after removing it from the Ribbon?
The Ribbon and the Quick Access Toolbar are separate interface elements in Excel. If you previously added the Form command to both areas, removing it from one does not automatically remove it from the other. You must remove it from the Quick Access Toolbar separately.




