Office Settings & Configuration

How to Remove the Data Entry Form Button in Excel

Camila MilosovichCamila Milosovich Nov 3, 2026 869 views

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.

How to Remove the Data Entry Form Button in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Locate the Quick Access Toolbar

Find the Quick Access Toolbar at the top-left corner of your Excel window, typically located just above or below the Ribbon.

2
Right-click the Form button

Hover your mouse over the Data Entry Form icon on the toolbar and right-click on it to open the context menu.

3
Select Remove

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 Right-Click Menu
Data Safety Guaranteed: This action removes only the shortcut button. It does not delete your worksheet data, VBA code, or any manually created data-entry forms.
Efficient Spreadsheet Management

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. 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
  2. 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and locate the Quick Access Toolbar at the top left of the application window.
  3. 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.
Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Intuitive user interface for effortless Quick Access Toolbar customization.Built-in Data Form features for rapid data entry without needing complex VBA.Lightweight, fast-loading, and completely free to download and use.
microsoft office alternative - wps office

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.