Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 08-13-2019, 03:39 PM
ExcelUser1102 ExcelUser1102 is offline Find All not working correctly Windows 10 Find All not working correctly Office 2016
Find All not working correctly
Join Date: Aug 2019
Posts: 1
ExcelUser1102 is on a distinguished road
Default Find All not working correctly

I have narrowed down this issue so I know what is happening but I don't know why it is happening. This was taken from a much larger workbook so it isn't a quick fix of just one cell, which is what this example might look like.

This is the issue: When doing a FindAll for the word "Bodily" on List2 within "Sheet" searching "By Rows" (which is the default), there are 3 items in the results, which is correct.
When the search is done within "Workbook", there is only 1 item and that is the one from the List1 tab. This search is not including the cells on List2.
Again, the source workbook is much larger and needs to be searchable for all tabs, so this is a larger issue than what is shown.
One interesting thing we have found is that if the search is done "By Columns", it correctly finds 4 items in the workbook.

Why would it find the cells correctly when searching by columns. No one would ever think to change than when doing a word search unless they knew this issue might exist.

I know it has something to do with a merged cell in B2:B4, but I don't know why it is behaving this way.

Can someone help explain why this is happening and how we can fix it.

Attached Files
File Type: xlsx FindAll_Issue.xlsx (12.3 KB, 6 views)
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing image in Word not working correctly reportmaster Word 1 02-09-2015 10:18 PM
Remote control not working correctly Gdukes PowerPoint 0 03-13-2014 03:48 PM
Find All not working correctly Find and Replace not working alance Word 2 01-24-2014 02:11 AM
Find All not working correctly Spell check not working correctly in table of form document troybuell Word 1 07-23-2012 12:08 PM
Paste not working correctly Word 2010 wapanap Word 0 09-13-2010 06:29 PM

All times are GMT -7. The time now is 03:12 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft