How to duplicate the text from upper/right cell quickly in Excel

Sometimes copying in Excel can be done in one command

When working in Excel, you sometimes need to copy the contents of the upper cell to the cell where the cursor is put. This operation is simple, it consists of four even more simple steps: 

  • Move cursor to the upper cell
  • Press CTRL+C (Copy)
  • Move cursor back to lower cell 
  • Press CTRL+V (Paste)

But when you need to do these steps many times, the operation becomes quite tedious.

The solution is very easy: use shortcut CTRL+D. The contents of the upper cell is duplicated immediately. You do not even need to move the cursor. Instead of performing four steps, you perform only one.

Similarly, if you need to copy the text from the left cell quickly, just press CTRL+R:

The usefulness of these two shortcuts grows even further when you need to duplicate the contents of a cell to several cells below. For example, if you need to copy the contents into 10 cells, select them all (including the cell to be duplicated):

Then press CTRL+D. All selected cells are filled with the contents of the very first cell:

CTRL+R command makes duplicating “to the right” in the similar way.

Shortcuts speed up your work. Ironically, these ones are the standard Excel shortcuts, but few people are aware of them. The only thing you should remember is: they do not work if a filter is applied on the Excel sheet.


Other articles


Мы получили ваше резюме.

Как только мы его изучим, мы свяжемся с вами.

Thank you!

We have received your message.

We will contact you once we read it.

Normally we reply within an hour
if the message is received between
7:00 and 15:00 GMT.

Thank you!

You have subscribed successfully.


+ Attach file

Мы внимательно изучим ваше резюме
и свяжемся с вами в ближайшее время