our blog

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

Sometimes copying in Excel can be done in one command.

In Excel, you sometimes need to copy the contents of the upper cell to the cell where the cursor is. This operation consists of four simple steps: 

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

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

The solution is very easy: use the shortcut CTRL+D. The contents of the upper cell are 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 quickly copy the text from the left cell, 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 populated with the contents of the very first cell:

CTRL+R command makes duplicating “to the right” similarly.

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

Recommended content

How to get rid of the “Failed to load built in plugin(s)” error in Xliff Editor 

Unfortunately, errors happen in every program We have caught a new error, this time in Xliff Editor, a text editor included in the Translation Workspace software package. Here’s what it looks like:  Failed to load built-in plugin(s): Failed to activate the plugin: … reason : … * * * The error happens due to the wrong configuration of […]

Haiti not Tahiti, Dominicana not Dominica 

Linguogeographic notes The country of Haiti occupies a third of the island of Hispaniola, once called Hayti and still called so in many languages, other than Romano-Germanic, due to the confusion of their speakers. The remaining two-thirds is occupied by the Dominican Republic, sometimes also called Dominicana. A highly puzzling region. Haiti is the poorest country in the Western Hemisphere and the only […]

Cherokee writing system: familiar but weird 

About using symbols A Native American chief named Sequoyah, also known to the world as George Guess, knew no English but often saw European settlers writing in it. His native language was Cherokee, which at that time (the early 19th century) did not yet have an alphabet. Realizing that sounds could be represented by signs and […]

The amusing homophony of English 

Amusing to tears In English, due to its twisted spelling, it is not always possible to exactly identify the word pronounced. What is meant by [raɪt]—right, rite, wright, write? Pronounced similarly and written differently, these words are called homophones. Lots of jokes are based on homophony. For instance, May 4 is celebrated as the so-called Star Wars Day because the […]

A bear’s service to aspiring translators 

That infamous awkward moment On an annoyingly regular basis, we find ourselves in the same situation: some John Smith says, “Hey, I know you do translations professionally, and my daughter (sister, niece) just happens to have graduated with a linguistics degree and is now looking for a job. She speaks English (German, French) so great! […]