How To Move Data From One Cell To Another In Excel

In this tutorial, learn how to move data from one cell to another in Microsoft Excel Sheet. You can shift your data to other cell or column using a keyboard or mouse. There are various methods which are given below to change the place of data.

So, let’s start learning each method with the step-by-step- guide given below.

Move Data From One Cell to Another Using Mouse in Excel

To move data to other cells or columns using the only mouse, you have to follow the below steps. Use only your mouse to perform this task in a few easy steps.

Step 1 Enter Data in Excel

First of all, you have to enter any number of data in the Excel Sheet. Let’ take an example of data as given in the image below.

move data from one cell to another Enter Data in Excel

The example contains numbers in column B from cell B2 to B7. you have to now move this data to the cells of column D. Follow the next steps after entering the data.

Step 2 Select Data with Hover Over the Corner and Hold Mouse Left Button

Select your entire data using your mouse. After that, you have to hover over the corner of the selected data. You can hover to any corner position to the left, right, top and bottom.

Now, hold your mouse left button when you get the pointer sign as move data from one cell to another.

move data from one cell to another Select Data with Hover Over the Corner and Hold Mouse Left Button

The above example showing the selected data. You can also find the pointer sign when you hover over the corner. Click the corner when you get the sign move data from one cell to another in the mouse pointer. Now, Keep your mouse hold for the next step.

Step 3 Drag-n-drop to the Cell to Move Data in Excel

You have to now drag your mouse to the required column cell. Drop the data when you reach the required cell to move to. It drops the whole data you have selected to move to the other cells.

Move Data From One Cell To Another Drag-n-drop to the Cell to Move Data in Excel

The above example showing the image which you get when you drag your mouse.

Step 4 Final Moved Data

This is the final output contains the moved data to the cell of column D. The data copied from cell D2 to D7.

Move Data From One Cell To Another Final Moved Data

You can also move any of your data after selection using your mouse. If you want to move your data using a keyboard, you have to use the step-by-step process given below.

Shift One Cell Data to Another Using Only Keyboard in Excel Sheet

This is the method of only using the keyboard to change your data position. It’s the simple cut and paste method to shift data to other column cells.

Step 1 Put Your Data in Cell of Excel Sheet

Here, you also have to enter your data first in any cell of the Excel. Perhaps, you want to move the data already exist in the Excel sheet.

Put Your Data in Cell of Excel Sheet

It depends upon you for which data you use. You can use any data to shift to other column cells. The above example showing the same data you have used in the above section.

Step 2 Select the Data Data Using Keyboard

Now, select your chosen data which you have to shift to the other cell. Use your keyboard left and right arrow key to move to the required data. Combination of shift and the arrow keys can be used to select the entire data.

Select the Data Data Using Keyboard

The above image showing the selected data to shift to the other column cells.

Step 3 Press ‘CTRL + X’ to Cut Data

You have to cut the selected cell to shift to the other column cell. For this, press the keyboard key ‘CTRL + X’ to cut the data in Excel Sheet.

Press 'CTRL + X' to Cut Data

The above image showing the screen which you will get after pressing ‘CTRL + X’. This showing you are using the above data to cut in Excel Sheet.

Step 4 Go to Cell to Paste Data

After you perform the above step, you have to go to the cell where you want to place data. Press keyboard arrow keys to visit the required place for data.

Go to Cell to Paste Data

The above example showing that you want to shift data to column D and start from cell D2.

Step 5 Press ‘CTRL + V’ to Paste and Move Data

The final step is to press the keyboard shortcut key ‘CTRL + V’. This is the key to paste the cut data to any required place of Excel Sheet.

Press 'CTRL + V' to Paste and Move Data

The above image showing the shifted data to column D.

Change Data from One Column to Another in Excel

In addition to above all, you can also change or move one column data to another column. You have to first choose the data which you want to move. After that, follow the step-by-step guide given below with screenshots.

Step 1 Mouse Hover Over the Column Containing the Data

You have to first take your mouse to the column name which contains the required data. The pointer of the mouse changes to a down arrow like shape as given in the image.

Mouse Hover Over the Column Containing the Data

The above image showing the data and the mouse pointer showing down arrow.

Step 2 Click Column Name to Select Data

Click the column name whose data you have to move. It selects all the cell of the clicked column name.

Click Column Name to Select Data

The above image showing the selected column containing the data to move.

Step 3 Mouse Right Click and Select ‘Cut’ Option

Now, you have to click the mouse right button to get various menu options. In the menu options, you have to select the ‘Cut’ option given on the menu.

Mouse Right Click and Select 'Cut' Option

You will get a highlighting column selection as showing in the image below.

Mouse Right Click and Select 'Cut' Option

Step 4 Click Column Name Where You Want to Shift Data

Click the column name to which you want to move the data. You will get a down arrow pointer for the mouse when you take your mouse to the column name.

Click Column Name Where You Want to Shift Data

The above example showing the select column where you have to place the data.

Step 5 Finally, press ‘CTRL + V’ to Paste Data

The final step is to paste the data using the keyboard shortcut ‘CTRL + V’. The below example image showing the pasted data to the new column.

Finally, press 'CTRL + V' to Paste Data

You May Also Like to Read

Reference
MS Office Excel Doc to Move Cell and Cell Content