Last Update: 1/4/2018
Click once on a cell or group of cells and note the black square in the lower-right corner of the selection box. Hover over the black square until you see a cross (+), then drag this selection to the right and/or down, to auto fill additional cells with data.
Auto fill will use the first increment found in the selected region (vertical and horizontal regions may have different increments) to fill the range. If you use the CTRL key while dragging, the fill will repeat the value(s) you've selected.
Double click the tiny corner also fills the column to have same length as left column.
Keywords:auto fill, cell, worksheet, cell value, repeat data