Can you please advise if Excel can "undo" if using the Find and Replace Feature?
E.g. Use the Find and Replace Feature to search for X within a worksheet that contains say ten results for X, then review the results by electing "Find Next", though after moving between results, subsequently desire to review a previous result using "undo".
I didn't know the answer, so I did what I would encourage you to do: go experiment. You're not going to break anything.
The process I used:
- opened a spreadsheet that had a recurring set of letters (among many others)
- selected FIND and REPLACE, changing ARK to AKR
- Went one at a time clicking on the "Next" button
- clicked on "Replace" for the first, third and fifth
- then clicked (three times) the "Undo" icon at the top of the screen
And in doing this I learned the answer to your question: "Yes"
That is to say, "Yes, you can undo changes made through Find and Replace"
To go back to my first point, though, one of the best ways to learn Excel is to "play" with it, take chances, try things out, experiment. Obviously, don't play with a spreadsheet that contains vital information that, changed, could cost you or your company millions. I "played" with a spreadsheet that gets totally refreshed every day and, once used, is not needed at all...... But give yourself permission to try things out.
That doesn't mean you shouldn't come and ask questions here, but the reality is that those of us who presume to answer questions sometimes find the answers ourselves--as I did in this instance--by experimenting. Sometimes we know the answer in advance because we'd discovered it by experimenting in the past.... That's why I encourage you to give yourself permission to do that, whenever possible.