Undo and redo

Revert and restore your changes, using the undo and redo features.

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.

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.

1
import Handsontable from 'handsontable/base';
2
import { registerAllModules } from 'handsontable/registry';
3

4
// Register all Handsontable's modules.
5
registerAllModules();
6

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

9
new Handsontable(container, {
10
  data: [
11
    ['A1', 'B1', 'C1', 'D1', 'E1'],
12
    ['A2', 'B2', 'C2', 'D2', 'E2'],
13
    ['A3', 'B3', 'C3', 'D3', 'E3'],
14
    ['A4', 'B4', 'C4', 'D4', 'E4'],
15
    ['A5', 'B5', 'C5', 'D5', 'E5'],
16
    ['A6', 'B6', 'C6', 'D6', 'E6'],
17
    ['A7', 'B7', 'C7', 'D7', 'E7'],
18
    ['A8', 'B8', 'C8', 'D8', 'E8'],
19
    ['A9', 'B9', 'C9', 'D9', 'E9'],
20
  ],
21
  rowHeaders: true,
22
  colHeaders: true,
23
  stretchH: 'all',
24
  height: 'auto',
25
  autoWrapRow: true,
26
  autoWrapCol: true,
27
  licenseKey: 'non-commercial-and-evaluation',
28
});

1
import Handsontable from 'handsontable/base';
2
import { registerAllModules } from 'handsontable/registry';
3

4
// Register all Handsontable's modules.
5
registerAllModules();
6

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

9
new Handsontable(container, {
10
  data: [
11
    ['A1', 'B1', 'C1', 'D1', 'E1'],
12
    ['A2', 'B2', 'C2', 'D2', 'E2'],
13
    ['A3', 'B3', 'C3', 'D3', 'E3'],
14
    ['A4', 'B4', 'C4', 'D4', 'E4'],
15
    ['A5', 'B5', 'C5', 'D5', 'E5'],
16
    ['A6', 'B6', 'C6', 'D6', 'E6'],
17
    ['A7', 'B7', 'C7', 'D7', 'E7'],
18
    ['A8', 'B8', 'C8', 'D8', 'E8'],
19
    ['A9', 'B9', 'C9', 'D9', 'E9'],
20
  ],
21
  rowHeaders: true,
22
  colHeaders: true,
23
  stretchH: 'all',
24
  height: 'auto',
25
  autoWrapRow: true,
26
  autoWrapCol: true,
27
  licenseKey: 'non-commercial-and-evaluation',
28
});

Known limitations

Not all user-triggered actions are recorded in the undo-and-redo history. Here’s the list of all unsupported features:

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	✓	✓