Office Settings & Configuration

Fix Missing Show Auto-Highlight Option in Excel Find and Replace

Maira Mehtab Sep 22, 2026 869 views

Question details

The user is unable to use the Show Auto-Highlight option in Excel's Find and Replace menu because the setting has disappeared.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Searching for specific data within a spreadsheet and attempting to have the search results automatically highlighted.
Observed behavior: The Show Auto-Highlight option is missing from the Find and Replace Focus menu after a recent Office 365 update, preventing search results from displaying with the selected highlight color.

Before you start

Verify your exact Office 365 subscription plan and update channel, as Microsoft frequently phases features in and out based on specific build channels like Insider or Enterprise versions.

Solution 1Recommended

Check Your Excel Product Update Channel

Determine if you are on an official stable release or an Insider build, as the Auto-Highlight feature may have been temporarily withdrawn from the stable version.

Microsoft sometimes temporarily removes features from the main update channels to investigate problems or improve functionality. The Show Auto-Highlight feature might currently be restricted to Office Insider builds or specific enterprise versions (such as the A3 business version).

Open Account Settings

Launch Microsoft Excel and click on 'File' in the top-left corner of the ribbon.

Navigate to Product Information

Select 'Account' from the left-hand sidebar menu.

Check the Update Channel

Look under the 'Product Information' section to see your current update channel (e.g., Current Channel, Monthly Enterprise Channel, or Beta Channel). If you are on a standard release, the feature is likely paused by Microsoft.

Solution 2

Submit Feedback to Microsoft to Restore the Feature

Report the missing feature directly to the Excel development team to request its return to the official release channel.

Free Microsoft Office alternative

Try WPS Office for Reliable and Stable Spreadsheet Features

If disappearing features and mandatory updates in Microsoft Excel are disrupting your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with a familiar interface and stable features that don't unexpectedly vanish.

1. Download WPS Office: Install WPS Office for free from the official website and open WPS Spreadsheet.
2. Open Your Excel File: Easily open your existing .xlsx or .xls documents with full formatting retention.
3. Use Find and Replace: Press Ctrl + F to bring up the Find and Replace dialog and easily locate your data with a stable, intuitive toolset.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) file formats.Stable and reliable Find and Replace functionality without unexpected feature removals.Free and lightweight, avoiding the heavy system usage of traditional Office suites.Familiar user interface that ensures a seamless and instant migration from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why did the Show Auto-Highlight option disappear from Excel?

Microsoft regularly updates Office 365 and occasionally withdraws features temporarily to fix bugs, optimize performance, or investigate issues. The feature may currently only be available to Office Insider beta testers or specific business licenses (like A3).

Can I get the Auto-Highlight feature back by joining the Insider program?

Yes, joining the Office Insider (Beta) channel may restore the feature as it provides early access to testing builds. However, Insider builds can contain bugs and are generally not recommended for critical daily business environments.

Is it possible to roll back my Excel update to restore the missing feature?

Yes, if you use Office 365 on Windows, you can use the Office Deployment Tool to revert to a previous build prior to the update that removed the Auto-Highlight option. However, doing so will pause future security patches and feature updates.

Office App Problems