Forum Discussion
Solved
How do I have Excel treat each file separately - for search, undo, etc.
Excel treats all files I have open as one. By that I mean there is one search box that works across all files open. If I want to search for different things in different files, I have to keep changin...
I thought I had wrapped this up by saying that the option to start independent instances of Excel by using the /X startup option is my solution. This makes each file independent with separate undo and find/replace boxes. But, I did not see that this morning when MS asked me to indicate the best solution. mathetes
Search and select
This option is located on the top right of the Start menu
In the options you can also select the worksheet.
Find and select cells that meet specific conditions
If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)
- Only now do I see that it is 365 ... believe that mathetes answer is more suitable.
Reading through doesn't hurt either 🙂
Anyway, I wish you a lot of fun and a pleasant day.
Nikolino