Office Settings & Configuration

How to Fix Text to Columns and Remove Duplicates Missing in Excel

Maira Mehtab Sep 28, 2026 869 views

Question details

The user is unable to find the Text to Columns and Remove Duplicates commands on the Excel Data tab.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Trying to clean and organize data using standard data tools, but the required buttons are not visible.
Observed behavior: The Text to Columns and Remove Duplicates commands are completely missing or unavailable on the Data ribbon interface.

Before you start

Ensure you have an active workbook open and are not currently in cell-editing mode (double-clicked inside a cell), as this can temporarily hide or gray out ribbon commands.

Solution 1Recommended

Restore Missing Commands via Customize Ribbon

The most common reason for missing commands is an accidentally modified or hidden ribbon interface. You can manually add these tools back to your Data tab through Excel Options.

Excel allows users to deeply customize the top ribbon menu. Occasionally, groups or specific commands can be accidentally removed, or a third-party add-in might have altered the default layout. Restoring them via the Customize Ribbon settings is the quickest fix.

Open Excel Options

Click on the 'File' menu in the top-left corner of the screen, then select 'Options' at the very bottom of the left sidebar.

Access Ribbon Settings

In the Excel Options dialog box, select 'Customize Ribbon' from the left navigation pane.

Locate Data Tools

Under the 'Choose commands from' dropdown menu on the left, select 'All Commands'. Scroll down the alphabetical list to find 'Text to Columns...' and 'Remove Duplicates'.

Add to Ribbon

In the right pane, expand the 'Data' tab. Click 'New Group' at the bottom to create a custom group. With your new group selected, click the 'Add >>' button in the middle to move the commands over.

Save Changes

Click 'OK' at the bottom of the window to apply your changes. Navigate back to your spreadsheet and click the Data tab to verify the commands are now visible.

Quick Ribbon Reset: If your ribbon has multiple missing items, you can easily restore the default layout by clicking the 'Reset' button at the bottom of the Customize Ribbon window and choosing 'Reset all customizations'.

Organize Data Easily with WPS Office

Use Data Tools Seamlessly in WPS Spreadsheet

WPS Spreadsheet features an intuitive, user-friendly interface where essential data management tools like Text to Columns and Remove Duplicates are always accessible on the default Data tab without requiring complex ribbon configurations.

1. Open WPS Spreadsheet: Launch WPS Office and open your existing workbook or create a new one.
2. Navigate to the Data Tab: Click on the 'Data' tab located in the main ribbon menu at the top of the screen.
3. Use Text to Columns: Select the column containing the data you want to split, then click the 'Text to Columns' icon to open the conversion wizard.
4. Remove Duplicates: Highlight your data range and click the 'Remove Duplicates' button on the same ribbon to instantly clean your dataset.

Completely free to download and use for daily data tasksFully compatible with all standard Microsoft Excel (.xlsx, .xls) formatsIntuitive ribbon interface with default Data tools ready to use immediatelyLightweight application that loads fast and runs smoothly on older devices

Frequently Asked Questions

Why are the Data tab commands visible but grayed out in Excel?

Commands like Text to Columns or Remove Duplicates will appear grayed out if you are actively editing inside a cell (cursor blinking in the formula bar), if multiple worksheet tabs are grouped together, or if the current worksheet is protected.

Can an Office update cause my ribbon commands to disappear?

Yes, occasionally a major Microsoft Office software update or a corrupted configuration file can cause custom ribbon settings to revert or hide certain tabs. Resetting the ribbon in the Options menu typically resolves this.

Is the Text to Columns feature available in the web version of Excel?

Yes, Text to Columns is available in Excel for the web under the Data tab. However, the interface and some advanced parsing options might differ slightly compared to the full desktop version.

Office App Problems