Forum Discussion
Solved
find and replace issue
when using find and replace in excel 2019 or 2021 and there is no results for search the application automatically hide the find and replace window and kept just the alert box and that is an issue because I need the find and replace window a long side with the alert box it said there is no results, I need both to appear to take a screenshot containing the search content and the result.
if there is some way to solve that, kindly help please.
- Thank you all
I found the solution and it turned out to be very simple
After writing the text in the search box, specifying the column or range to be searched in, and pressing Find All, the alert box will appear, which says that the search does not match any of the results, and of course the find and replace window will disappear, then click anywhere other than the Excel program, and the find and replace window will appear side by side Along with the alert box.
- Thank you all
I found the solution and it turned out to be very simple
After writing the text in the search box, specifying the column or range to be searched in, and pressing Find All, the alert box will appear, which says that the search does not match any of the results, and of course the find and replace window will disappear, then click anywhere other than the Excel program, and the find and replace window will appear side by side Along with the alert box. Not as far as I know. You'll have to take a screenshot of the Find and Replace dialog and a separate screenshot of the alert box.
- This is what I actually do, but it costs me more minutes, which negatively affects and slows down my work performance
