When working with Excel, it is a common scenario that we need data in a specific row or column, but we have inserted the data in other rows or columns. In this case, it is tiring to put the data again on the required rows or columns. Instead, we can simply move the inserted data to the required rows or columns. In this article, I will show you 5 suitable ways to move data from one cell to another.
Download Practice Workbook
You can download our practice workbook from here for free!
5 Suitable Ways to Move Data from One Cell to Another in Excel
Say, we have a dataset of Product Sales containing Order Date, Product, Quantity (Pc), and Unit Price columns. Now, we want to move the Unit Price column (cells E4:E16) rightward (cells F4:F16). You can follow any of the ways given below to do this.
1. Dragging and Dropping with Mouse
The quickest way to move data from one cell to another is to use the drag and drop your left mouse button. Follow the steps below to do this.
📌 Steps:
- First and foremost, select cells E4:E16.
- Afterward, place your cursor on the right corner of your selection.
- As a result, a move cursor will appear.
- Now, left-click on your mouse and drag the selection to column F.
Thus, the entire selection will be moved to cells F4:F16. And, the outcome should look like this.
2. Using Cut and Paste Options
You can also use the cut-and-paste options to move data from one cell to another in Excel. Say, you have Unit Price data in D4:D16 cells which you want to move to E4:E16 cells. Go through the steps below to do this.
📌 Steps:
- First, select cells D4:D16.
- Following, click on your right mouse and choose the Cut option from the context menu.
- Afterward, click on cell F4 and right-click on your mouse button.
- Subsequently, choose the Paste option from the context menu.
Thus, you will be able to move all your desired data from one cell to another. And, the final result should look like this.
3. Using Keyboard Shortcuts to Move Data from One Cell to Another
Another quick way to move data from one cell to another is to use keyboard shortcuts. Follow the steps below to accomplish this.
📌 Steps:
- At the very beginning, select cells which you want to move (cells E4:E16 here).
- Following, press Ctrl + X.
- Afterward, click on cell F4 and press Ctrl + V.
As a result, your task will be accomplished. And, for example, the outcome should look like this.
4. Using the Insert Cells Command
Besides, you can move data from one cell to another by using the Insert tool. Go through the steps below to accomplish this.
📌 Steps:
- First, select cells E4:E16.
- Following, go to the Home tab >> Cells group >> Insert tool >> Insert Cells… option.
- As a result, the Insert window will appear.
- Subsequently, choose the option Shift cells right option and click on the OK button.
As a result, you will be able to move the selected data to your desired locations. And, the outcome should look like this.
5. Using a VBA Code to Move Data from One Cell to Another
Moreover, you can use a VBA code to move data from one cell to another. Follow the steps below to do this.
📌 Steps:
- First, go to the Developer tab >> Visual Basic tool.
- As a result, the VB Editor window will appear.
- Following, go to the Insert tab >> Module option.
- As a result, a new module named Module1 will be created.
- Following, click on Module1 and write the following code in the code window.
Sub MoveCellData()
Range("E4:E16").Cut Range("F4:F16")
End Sub
- Subsequently, press Ctrl + S on your keyboard.
- As a result, a Microsoft Excel window will appear.
- Following, click on the No button.
- As a result, the Save As dialogue box will appear.
- Following, choose the Save as type: as .xlsm file and click on the Save button.
- Afterward, go to the Developer tab again and click on the Macros tool.
- As a result, the Macro window will appear.
- Following, choose the MoveCellData macro and click on the Run button.
Thus, you will see cells E4:E16 shifted to F4:F16.
How to Copy Data from One Sheet to Another in Excel
Now, you might need to copy data from one sheet to another sheet in Excel sometimes. Follow the steps below to accomplish this.
📌 Steps:
- First, select the cells you want to copy (cells E4:E16 here) from the sheet (Sample Dataset) from which you want to copy data.
- Subsequently, right-click on your mouse and choose the Copy option from the context menu.
- Afterward, click on the cell (cell E4 here) of the desired sheet where you want to paste the values.
- Following, right-click on your mouse and choose the Paste option from the context menu.
As a result, you will be able to acquire your desired result. And, the outcome would look like this.
Conclusion
So, in this article, I have shown you 5 suitable ways to move data from one cell to another in Excel. Read the full article carefully and practice accordingly. I hope you find this article helpful and informative. You are very welcome to comment here if you have any further questions or recommendations.
And, visit ExcelDemy to learn about many more Excel problem solutions, tips, and tricks. Thank you!
FWIW, I would argue that this article is poorly named. You are not moving data. When you move a box from point A to point B, the box is no longer at Point A when you are done. When you move a file in your file system rather than copy it, it was one place, now it is someplace else. In all of your examples, the data is still present in the original location, so you did not move the data. You do several variations so I don’t know if you would say referenced, or queried, or looked up, but referenced is probably closest. I was disappointed because I actually want to move data. I have many rows with a different number of columns, but I know the last 3 columns are consistent, so I want to write a formula that says “find the last non-blank cell (which I can do) and MOVE IT to this cell. Then I can do that again, because now I know what the new last cell is and so on. That would allow me to line up the constant columns. Anyway, not asking you to solve my problem, just explaining mu use case for an actual move and explaining why I believe your title is not technically accurate and it lead me astray since I was actually looking to move a cell.
Regards,
Bill
Hello Bill Allcock, Excel formulas can’t move data. So, we’re making a copy of the value. You need to use VBA to do so. Moreover, you can send us your sample Excel file to [email protected] and we will try to solve your problem using VBA.
I agree with Bill NO MOVING actually occur in these examples. The title should be “Excel Formula to Copy Data from One Cell to Another”. I just want to move a value from the debit column to the credit column when a status column is marked. This was a waste of time.
Hi ROD, we are really sorry for your experience, there is no Excel formula to move data from one cell to another actually. So we have revised the whole write-up. Thanks for your (Bill too) valuable feedback. We hope you will be with us in the coming days as well.
-ExcelDemy Team