Restore Missing Data Validation in the Excel Microsoft 365 Ribbon
Question details
The user needs to restore the Data Validation command to 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.
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.
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.
Select the Search box at the top of Excel, type Data Validation, and select the command if it appears.
On Windows, go to File > Options > Customize Ribbon. On Mac, open Excel > Preferences > Ribbon & Toolbar.
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.
Select OK or Save, then open the Data tab and check the custom group for Data Validation.
Update Microsoft 365 and run an Online Repair
Use this method if the command remains missing or Excel reports a problem after an update.
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.

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.




