Excel Data Entry Keyboard Shortcuts

Use Shortcut Keys Enter the current Date:  Ctrl + ; Enter the current Time:  Ctrl + Shift + ; Copy Value from cell above:  Ctrl + Shift + ' Copy Formula (exact) from cell above:  Ctrl + ' Copy Formula (relational reference) from cell above:  Ctrl + D

Enter Data in Multiple Cells -- Ctrl + Enter
Select all the cells in which you want to enter the same value or formula Type the value or formula in the active cell Hold the Ctrl key and press Enter

Copy Data to Adjacent Cells
Select the range, starting with the cell that contains the data to be copied Use a shortcut key to fill right or down: Fill Right -- Ctrl + R Fill Down -- Ctrl + D