Say I’m working with two workbooks open.
I’ll often be copying text/numbers from cells and pasting it into another workbook, using the find and replace function to find these respective text/numbers.
What Excel does, is it lnks the Find/Replace window for the two seperate workbooks that are open. As a result, this causes a lot of confusion because Excel will be searching the original workbook instead of the workbook I want to search in. I then have to take the time to click the workbook I want to search in before using the Find/Replace window.
Is there an option to make it so each workbook has its own find/replace window? Why would Excel do this? It seems unintuitive. Google Sheets seems way better in that regard.