How to Quickly Copy a Cell Down or to the Right in Your Excel Worksheet

Sometimes in your Excel worksheet, you need to input the same contents into multiple cells. And in this article, we will show you how to fulfill this task by copying a cell down or to the right in worksheet.

In certain circumstance, you need to input the same contents into a range. If those cells are adjacent, you can first input the contents into a cell and then copy it down or to the right. And the target area can be a cell or a range. Instead of using the copy and paste feature or the fill handle in Excel, here you can also use the two shortcut keys combos to realize this task easily and quickly.

Copy a Cell Down

In the image below, you can see that cell B5 already contains contents. And now you need to copy the value into cell B6. And below are the steps to copy cell down.An Example for Copy Cell Down

  1. Click cell B6 in this worksheet.
  2. And then press the shortcut keys “Ctrl +D” on the keyboard. Immediately you will see the same contents appear in the cell B6.Copy Down

There are only two steps in this process, which turned out to be very easy.

On the other hand, if you want to copy this cell to more than one cell in this column, you need to make some modification.

  1. Click cell B5 and hold your mouse.
  2. After that, move your mouse downwards and select the target range.
  3. And then, press the shortcut keys “Ctrl +D” on the keyboard.A Range

When you need to fill more than one cell, you need to select the first cell and make sure that it is the first cell in this selected range. Otherwise, you cannot fill the target cells with the same contents. This is because the first cell of this range contains nothing. Besides, of course you can select the cell B5 and B6 if you only need to fill cell B6, but it is unnecessary in this condition.

Copy a Cell to the Right

In this part, you can use another shortcut keys to copy a cell to the right cell. Here we will use the same example.

  1. Click the cell C5 on the keyboard.
  2. And then press the shortcut keys “Ctrl + D” on the keyboard. Thus, the same contents will appear in cell C5.Copy to Right

On the other hand, when you need to copy the cell to more than one cell, you can follow the steps below.

  1. Click cell B5 and hold your mouse.
  2. Next move your cell rightwards and select the target cell.
  3. And then press the shortcut keys “Ctrl + D” on the keyboard. You will see that the same contents will appear in those cells.More Cells

Here you also need to select the original cell B5 in this range and make sure that it is the first cell of the range.

From the above analysis, you can see that the usage is very easy, and the difference between the two shortcut keys combos is the direction. “D” refers to “down” and “R” refers to “right”. And make sure that the original cell is the first cell in the range.

Choose Proper Backup Strategy

In your computer, you will certain make some important Excel files. And in those files, you have stored many essential data and information. However, once data disaster takes place, you will lose access to your files. And in order to repair Excel data error, you can now apply our potent recovery tool. With this tool at hand, you can repair even a severely damaged Excel file.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair Word error and outlook repair software products. For more information visit www.datanumen.com

Comments are closed.