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!


Julia K.

Microsoft Certified Trainer to the Rescue!

100+ hours
if (isMyPost) { }