When what you need to type into a cell on an Excel worksheet is exactly the same as what's already in the cell above, simply type Ctrl+" (hold down control and press the quotation mark) to duplicate the cell above!

This shortcut also works when entering data into an Access table.

Related: type Ctrl+; (semicolon) to enter today's date!