Excel Quick Tip: Quickly and Easily Copy Data from Cell Above
Sometimes you need to repeat the data or formula from just one cell, and you don't want to bother with copy and paste.
You can quickly copy the contents of a cell to the cell just below it:
- Click in the cell just below the cell you want to copy
- Press CTRL + ' (apostrophe)
- Press ENTER
It's that simple!