Fix Excel Find and Replace Blank Cells Not Working on Mac
Question details
Users encounter a 'We couldn't find anything to replace' error when attempting to use 'Replace All' for blank cells in Excel on Mac or Microsoft Surface devices.
- Product
- Microsoft Excel
- Device & OS
- Mac and Microsoft Surface
- Scenario
- Using the Find and Replace dialog to batch-fill empty cells with a specific value across a selected range.
- Observed behavior
- Clicking 'Replace All' fails and generates an error message, despite blank cells clearly existing within the selected dataset.
Ensure you have selected the specific range of cells you want to modify, rather than the entire worksheet, to prevent Excel from attempting to process millions of unused cells.
Use 'Replace' Individually Instead of 'Replace All'
Bypass the known platform-specific bug in Mac and Surface Excel by replacing blank cells one by one instead of using the batch command.
In certain versions of Excel for Mac (such as 16.47) and Surface devices, the 'Replace All' command fails when the 'Find what' field is empty. Clicking the singular 'Replace' button bypasses this error and successfully processes the blank cells.
Highlight the specific group of cells that contain the blank spaces you wish to fill.
Press Cmd + F on Mac (or Ctrl + F on a Surface), then navigate to the 'Replace' tab in the dialog box.
Ensure the 'Find what' text box is completely empty. Type your desired replacement text or number into the 'Replace with' text box.
Click the 'Replace' button repeatedly to fill each blank cell one at a time. Do not click 'Replace All'.
Update Excel and Test in a New Workbook
Software bugs are frequently patched in routine updates. Installing the latest version of Excel may restore the 'Replace All' functionality.
Easily Replace Blank Cells with WPS Spreadsheet
Avoid platform-specific Excel bugs entirely by opening your file in WPS Spreadsheet. It effortlessly handles batch operations like replacing blank cells across your dataset on any operating system, including macOS and Windows.
- 1. Open your file in WPS: Launch WPS Spreadsheet and open your existing Excel file.
- 2. Highlight the data: Select the range of cells containing the blank entries you need to replace.
- 3. Access Find and Replace: Press Ctrl + H (or Cmd + H on Mac) to instantly pull up the Find and Replace dialog box.
- 4. Execute Replace All: Leave the 'Find what' field blank, type your new value in 'Replace with', and click 'Replace All' to fill all gaps at once.
Frequently Asked Questions
Why does Excel say 'We couldn't find anything to replace' when my cells are clearly blank?
This is a recognized platform-specific bug occurring in certain builds of Excel for Mac (such as version 16.47) and some Microsoft Surface devices. The 'Replace All' command fails to register empty string values, even though the individual 'Replace' button recognizes them perfectly.
Is there a shortcut to fill blank cells without using Find and Replace?
Yes. Select your data range, press F5, click 'Special', and choose 'Blanks' to highlight all empty cells. Type your replacement value, then hold down Ctrl (or Cmd on Mac) and press Enter. This will instantly populate all the highlighted blank cells with your entered value.
Does this 'Replace All' error affect the Windows version of Excel?
The bug is predominantly reported by macOS and Microsoft Surface users. Standard Windows desktop versions of Excel usually execute the 'Replace All' command for blank cells without returning this specific error.
