Undo does not work

Issue

You edit the text of an item then press enter. But you want to redo but nothing happens after press Ctrl + Z on the keyboard or redo button in Excel.

Undo button in Excel
The Undo button is on the right of the Save button

Cause

The reason is that Excel does not allow you to undo what Auto-Fit has changed in your worksheet. This is nature of Excel when it does not allow undoing any programmatically change.

How to fix

We have a workaround solution. By turning off the Auto-Fit function when editing and apply it later after editing you can achieve the same result.

Here is how to do it:

  1. From the FMEA Analysis ribbon tab, uncheck Auto-Fit to turn off the Auto-Fit function of FMEA Analysis.
    Disable Auto Fit With Callout
  2. Edit the items you want as normal (undo is working now).
  3. Select the items that you want to apply Auto-Fit and press Fit Items. Items’ heights are adjusted to fit the content.
    Auto Fit after editting