How to copy data from cell to cell in Microsoft Excel?

When working with Microsoft Excel, it is important to know many subtleties for greater convenience and greater time savings. Today we will talk about how we can copy data from one cell to another and how to do the same if we have a range of cells. Go!

Copying data from one cell

If you are faced with a situation where data has been placed in the wrong cell and you are not very good with the computer, then now you will learn how to transfer this information to another cell. And it's very easy to do.

Method 1. Using hot keys

1. Left-click on the cell from which you want to copy information.
   
2. Press the key combination on your keyboard Ctrl + Cto copy data from the selected cell (note that when you press this combination, the cell borders will become dotted).
   
   
   If you press Ctrl+X instead, the data will be “cut” from the first cell, which means that the initial cell will become empty after the action is completed.
   
   
   
3. Click on the cell where you want to paste the selected data and press the key combination Ctrl + V.
   

Method 2: Using the context menu

1. Right-click on the data cell.
   
2. Click Copy or Cut out depending on your needs.
   
   

   
   
   

3. Right-click on the empty cell where you want to move the information, and in the context menu, click on Insert.
   
   

   
   

The result will be the same.

Copy a range of cells

If you have several cells that need to be copied, then use one of the options below.

Method 1: Using mouse selection

If the data is located nearby and forms a rectangular area, then select this area by holding the left mouse button with one click.

As a result, this area should darken a little (except for the cell where the selection started).

Next, use hot keys or the context menu to copy or cut data to another range (how to work with them is described above).

It is not necessary to outline the area where the data will move. You just need to click on the cell that will indicate the upper left edge of the new range.

Method 2. Selecting data using Ctrl

There are times when the data is separate or its range does not form a rectangle.

In this case, you can still copy data from cells in parts using the methods already described above, but it is much easier to use the key Ctrl on keyboard.

To do this, hold down this very button and select the data to move with the left mouse button (you can click, you can circle). At the same time, do not forget that The Ctrl key must be constantly held down.

Once the data is highlighted, press Ctrl and use already known methods for cutting or copying information.

Сonclusion

Of course, if you are at all familiar with a computer, then these tips will seem funny to you, but many people do not know that there are some ways to move data from cell to cell in Excel. We hope that some of the readers found this material useful.