For work I regularly download bills of materials that are automatically grouped by level. I need to search a few of these for a specific part number that will likely be found on level 4 or 5. These bills of materials can be thousands of items long with many kits inside kits at different levels, so normally I leave my groups collapsed to level 1. Then I can do a Find All and it will show me which level 1 group contains the part I’m looking for. I follow in this fashion until I expand the group at which I find the cell I’m looking for.
For some reason now Excel won’t find anything in any cell that’s part of a collapsed group. I have to expand every group as far as it will go to ensure that I’m searching the entire list. Has anyone had any issues with this? Did I accidentally click on an option that’s messed up my Find function?
I’m using the most current version of the MS365 Excel app on Windows 10 Enterprise.
