Undo/Redo

Executing any code that changes a spreadsheet clears Excel's Undo/Redo stacks. This means if you modify a formula and run a macro to change number format, you can't use Undo to revert to the original formula. This is a limitation of Excel, not the add-in or macro, with no easy workarounds.

Excel add-ins accept this loss of Undo/Redo functionality as a trade-off for their benefits. However, we believe customers of our enterprise-grade solutions shouldn't sacrifice functionality. Therefore, we built our own Undo/Redo stacks to restore most of this lost functionality. Managing custom Undo/Redo stacks is complex and costly, which is why few add-ins offer this feature.

Macabacus' Undo/Redo is designed to work seamlessly in the background, and uses the native Excel shortcuts, and , and Quick Access Toolbar buttons to trigger Undo/Redo operations. Macabacus' Undo/Redo options can be set in the Excel > Undo / Redo section of the Settings dialog (see below). You can set the maximum number of cells for which Macabacus Undo/Redo is available—however, too many cells may slow performance. Select which formatting properties you want Macabacus to undo/redo (deselecting properties may improve performance), or disable Macabacus' Undo/Redo capability altogether.

Macabacus' Undo/Redo works seamlessly in the background, using native Excel shortcuts (Ctrl+Z and Ctrl+Y) and Quick Access Toolbar buttons. Set options in theExcel > Undo / Redo section of the Settings dialog (see below). You can adjust the maximum number of cells for Undo/Redo, select which formatting properties to track (deselecting properties may improve performance), or disable this feature altogether.

Macabacus' Undo/Redo isn't perfect due to Excel's limitations. For instance, it cannot undo row/column insertion/deletion.

_{This documentation refers to the latest Macabacus version. Some features and descriptions of these features may not apply to older versions of Macabacus. Update your Macabacus software to take advantage of the latest features.}