Office Settings & Configuration

Restore Missing Data Validation in the Excel Microsoft 365 Ribbon

Chanuka GeekiyanageChanuka Geekiyanage Nov 20, 2026 868 views

Question details

The user needs to restore the Data Validation command to the Excel Microsoft 365 ribbon.

Restore Missing Data Validation in the Excel Microsoft 365 Ribbon
Product
Microsoft Excel for Microsoft 365
Device & OS
not provided
Scenario
The user wants to access Data Validation from the Data tab after an Office update.
Observed behavior
The Data Validation command is missing from the Data tab, but it may still be available through Search or ribbon customization.
Before you start

Open Excel and check the Data tab, including any collapsed groups that may appear when the window is narrow. Note your Office version under File > Account if you need to troubleshoot further.

Solution 1Recommended

Find Data Validation and add it to the ribbon

Use Excel Search for immediate access, then customize the ribbon if the command is available but not visible.

1
Search for the command

Select the Search box at the top of Excel, type Data Validation, and select the command if it appears.

2
Open ribbon settings

On Windows, go to File > Options > Customize Ribbon. On Mac, open Excel > Preferences > Ribbon & Toolbar.

3
Add the command

Choose All Commands from the command list and find Data Validation. Select the Data tab, create a new custom group if needed, and use Add to place the command in that group.

4
Save the changes

Select OK or Save, then open the Data tab and check the custom group for Data Validation.

Command list may vary: If Data Validation is not listed or ribbon customization is unavailable, update Office and try repairing the installation.
Free Microsoft Office alternative

Use WPS Spreadsheets as an alternative for data validation

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. It supports Microsoft Excel formats to help you move between applications, though it does not repair the Excel ribbon.

Use spreadsheet data validation tools to set entry rules.Open and save Microsoft Excel XLSX and XLS files.Work in a familiar ribbon-style interface.Move between Office files with a lightweight, free application.
microsoft office alternative - wps office

Frequently Asked Questions

Where is Data Validation normally located in Excel?

Open the Data tab and look in the Data Tools group. If the ribbon is compressed, expand the group or search for Data Validation using the Search box at the top of Excel.

Can I use Data Validation if its ribbon button is missing?

If the command appears in Excel Search, select it there. You can also look for it under All Commands in the Customize Ribbon settings and add it to a custom group.

What if Excel says Microsoft 365 is already up to date?

On Windows, open Settings > Apps > Installed apps, find Microsoft 365, and choose Modify > Online Repair if available. Reopen Excel after the repair and check the Data tab.

What should I send support if Data Validation is still missing?

Capture screenshots of your Office version under File > Account, the Data tab, and the command list in Customize Ribbon. Send them to Microsoft Support or your IT administrator.