Excel add-ins support undo behavior. This preserves both actions performed by Excel JavaScript APIs and actions performed by the user in Excel. These actions are saved in theundo stack for an individual user, allowing the user to step back through their actions when desired.

Undo grouping

The Excel JavaScript API also supports undo grouping. This allows you to group multiple API calls into a single undoable action for your add-in user. For example, if your add-in needs to make several different updates across multiple worksheets in response to a single user command, you can wrap all those updates in a single group. This is done with themergeUndoGroup property provided to theExcel.run function.

If an API within the group doesn't offer undo support, theUndoNotSupported error is thrown to let you know that the operation can’t be grouped. Your add-in should gracefully handle this error and present a reasonable message to the user.

The following code sample shows how to merge multiple actions withmergeUndoGroup set totrue.

await Excel.run({ mergeUndoGroup: true }, async (context) => {     const sheet = context.workbook.worksheets.getActiveWorksheet();     let range = sheet.getRange("A1");     range.values = [["123"]];         await context.sync();         range = sheet.getRange("B2");     range.values = [["456"]];    await context.sync(); });

Unsupported APIs

Most Excel JavaScript APIs do support undo actions. However, see the following table for a list of APIs that do not support undo behavior.

See also

• Excel JavaScript object model in Office Add-ins