When finished, release the mouse button.When the pointer changes to a black plus sign, press the Left mouse button, and drag left, right, up or down, across one or more.

Point to the Fill Handle - the black square at the lower right.Select the cell that contains the data to be copied.

Point to the bottom right corner of the selected cell, and drag, to quickly fill adjacent cells. Also, see the mouse double-click shortcuts, for other timesaving tips. Use these mouse shortcuts to quickly fill adjacent cells.

Copy Formula (relational reference) from cell above: Ctrl.

Copy Formula (exact) from cell above: Ctrl + '.

Copy Value from cell above: Ctrl + Shift + '.

Use a shortcut key to fill right or down:.

Select the range, starting with the cell that contains the data.

Type the value or formula in the active cell.

Select all the cells in which you want to enter the same value.

Watch this short video to see the keyboard shortcuts for enteringĭates and times in a worksheet.

Enter the current Time: Ctrl + Shift +.

Use a shortcut key to quickly enter the date or time in your spreadsheet:

Go to the Excel Shortcuts page for an interactive list, and to get the file.

Here are some time-saving Microsoft Excel shortcuts to use when you're entering data.

More Data Entry Tutorials Data Entry Shortcuts

Quick test paste