How to undo find and replace?


I used “find and replace” to change 25 cells in a Calc document. I made a mistake: I forgot to check “entire cells”, hence several cells I did not mean to replace were replaced.

How do I undo this? Using “Undo” reverted the changes one by one, and only up to ~8.

Version: / LibreOffice Community
Build ID: d1d0ea68f081ee2800a922cac8f79445e4603348
CPU threads: 8; OS: Mac OS X 12.6; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded


That is odd.

  • If I use Find and Replace > Replace All to change 41 instances then a single Ctrl+Z undoes all replacements.
  • If I replace individually for 30+ instances then the same number of Ctrl+Z undoes them all.

In the event of a mishap I find closing without saving (or File > Reload) returns me to my last save, from where I can normally remember what to add back.

Following the method given in this Help link, Undo I see that I have 100 Undo steps available which I guess is default…

1 Like

Hi EarnestAl,

Thank you for your reply. I don’t know how to explain this, but this Undo feature is working today. I could swear it wasn’t working yesterday. What is more, In the Edit Menu, Undo, Redo, and Repeat list, after a colon, what type of action they will perform (e.g. Undo: Replace). I had never seen this before!

In any case, it’s working. Thank you very much!

It’s there for ages.