2

I am using Excel for Mac version 16.28 and don't see how I would be able to Undo (Command Z) more than once as after undoing once a second undo will just undo the first undo and I have the state I started out with.

This doesn't seem to be an issue for other people.

Is there a setting to allow a deeper undo-redo chain in Excel for Mac?

1 Answer 1

4

Have you actually tried?

As I have used CommandZ multiple times on formulae I have edited several times and it steps back through the changes sequentially. Even changes sheets as necessary.

On version 16.29 & 365, the help file says 100 actions can be undone but there are exceptions...

Just tested by entering 0 to 9 in separate cells - CommandZ goes back through deleting them in the order they were entered.

8
  • Yes, obviously I have tried it... I hope a reinstall will help
    – Ramen
    Jun 14, 2020 at 20:29
  • 1
    @Ramen just checked the excel for mac help and it says it can undo the last 100 actions but does warn some actions cannot be undone.
    – Solar Mike
    Jun 14, 2020 at 20:37
  • 1
    @Ramen - reinstalling is a last resort. You may have a preference saved that limits your undo buffer to 1 instead of 100. Reinstalling won’t reset these settings meaning you’ll go through a ton of work for naught. Take some time and do a little detective work to see where the issue might be.
    – Allan
    Jun 15, 2020 at 1:12
  • This checks out. I would triage before reinstalling - make a new user account on the mac - sign in and do a quick test. That way you’ll know it’s a user preference or not a user preference. Well done everyone
    – bmike
    Jun 15, 2020 at 1:14
  • 1
    It's probably time to wipe out the Excel preferences if it's not behaving properly. The new user account will test if the prefs are damaged. If the new user works, the preferences are likely the culprit. Check Microsoft's guide here: support.microsoft.com/en-us/help/975724/… Jun 15, 2020 at 3:37

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .