Sunday, July 27, 2014 – Permalink –
In Excel 2007+. the number of levels of the "undo stack" was increased from 16 levels to 100.
Setting AutoFilters, showing/hiding detail in PivotTables, and grouping/ungrouping in PivotTables are now reversible.
And the undo stack is not cleared when Excel saves, be it an AutoSave or a Save by the user.
If you think the number of undos should be changed, here's how:
Modify the number of undo levels
If you want to clear the undo stack, just run a macro such as:
Sub ClearUndo() Range("A1").Copy Range("A1") End Sub
Clearing the Undo stack
See all Topics excel
<Doug Klippert@ 3:51 AM
Comments: Post a Comment