Handsontable

a minimalistic Excel-like data grid editor for HTML, JavaScript & jQuery

Drag-down

Notice the little square (fill handle) in the corner of the selected cell. You can drag it (drag-down) to repeat the values from the cell.

Double click the fill handle in cell B4 (value "30") to fill the selection down to the last value in neighbouring column, just like it would in LibreOffice or Google Docs.

	A	B	C	D	E
1		Kia	Nissan	Toyota	Honda
2	2008	10	11	12	13
3	2009	20	11	14	13
4	2010	30	15	12	13
5	2011
6	2012
7

Edit in jsFiddle

$("#example1").handsontable({
  startRows: 8,
  startCols: 5,
  rowHeaders: true,
  colHeaders: true,
  minSpareRows: 1,
  fillHandle: true //possible values: true, false, "horizontal", "vertical"
});

var data = [
  ["", "Kia", "Nissan", "Toyota", "Honda"],
  ["2008", 10, 11, 12, 13],
  ["2009", 20, 11, 14, 13],
  ["2010", 30, 15, 12, 13],
  ["2011", "", "", "", ""],
  ["2012", "", "", "", ""]
];

$("#example1").handsontable("loadData", data);

For more examples, head back to the main page.