Undo and redo

Table of contents

• Overview
• Basic demo
• Related keyboard shortcuts
• Related API reference

Overview

This feature allows you to revert changes made in the data grid. It is very useful in a normal day-to-day routine, especially when the change is unintentional. This feature stacks the changes made with the user interface of the grid. Modifications done programmatically are omitted.

The basic methods are undo() and redo(). The undo() method rolls back the last performed action, and the redo() method restores it.

This feature is provided by the UndoRedo plugin, and is enabled by default.

TIP

Not all user-triggered actions are covered by this feature. See the below list of actions that won't be added to the history of changes:

• Sort
• Filter
• Move column
• Move row

Basic demo

Make some changes to the grid below and the use the Ctrl/Cmd + Z command to redo the previous state. Then, use Ctrl/Cmd + Y (or Ctrl/Cmd + Shift + Z) to restore it.

const container = document.querySelector('#example'); const hot = new Handsontable(container, { data: Handsontable.helper.createSpreadsheetData(10, 5), rowHeaders: true, colHeaders: true, stretchH: 'all', height: 'auto', licenseKey: 'non-commercial-and-evaluation' }); <script src="https://cdn.jsdelivr.net/npm/handsontable@12.0/dist/handsontable.full.min.js"></script> <link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@12.0/dist/handsontable.full.min.css" /> <div id="example" class="hot "></div>

const container = document.querySelector('#example');

const hot = new Handsontable(container, {
 data: Handsontable.helper.createSpreadsheetData(10, 5),
 rowHeaders: true,
 colHeaders: true,
 stretchH: 'all',
 height: 'auto',
 licenseKey: 'non-commercial-and-evaluation'
});

Related keyboard shortcuts

Windows	macOS	Action	Excel	Sheets
Ctrl + Z	Cmd + Z	Undo the last action	✓	✓
Ctrl + Y	Cmd + Y	Redo the last action	✓	✓
Ctrl + Shift + Z	Cmd + Shift + Z	Redo the last action	✓	✓

Related API reference

• Configuration options:
  • undo
• Core methods:
  • clearUndo()
  • isRedoAvailable()
  • isUndoAvailable()
  • redo()
  • undo()
• Hooks:
  • afterRedo
  • afterRedoStackChange
  • afterUndo
  • afterUndoStackChange
  • beforeRedo
  • beforeRedoStackChange
  • beforeUndo
  • beforeUndoStackChange
• Plugins:
  • UndoRedo