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.
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.
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.
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 .
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 in the mouse pointer. Now, Keep your mouse hold for the next 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.
The above example showing the image which you get when you drag your mouse.
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.
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.
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.
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.
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.
The above image showing the selected data to shift to the other column cells.
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.
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.
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.
The above example showing that you want to shift data to column D and start from cell D2.
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.
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.
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.
The above image showing the data and the mouse pointer showing down arrow.
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.
The above image showing the selected column containing the data to move.
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.
You will get a highlighting column selection as showing in the image below.
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.
The above example showing the select column where you have to place the data.
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.
You May Also Like to Read
- Copy Data In Alternate Rows Selected In Excel
- Quickly Select All Cells Of A Column In Excel
- Autofill Dates, Months And Current Time In Excel Sheet
Hope, you like this post of how to move data from one cell to another. If you have any query regarding the tutorial, please comment below.
Also tell me, which method you are using to shift data from one cell to another cell.