Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Move Data from One Cell to Another in Excel (5 Ways)

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.

Sample Dataset to Move Data from One Cell to Another


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.

Using Mouse Drag and Drop to Move Data from One Cell to Another in Excel


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.

Choose the Cut Option to Move Data from One Cell to Another in Excel

  • Afterward, click on cell F4 and right-click on your mouse button.
  • Subsequently, choose the Paste option from the context menu.

Choose Paste Option to Move Data from One Cell to Another in Excel

Thus, you will be able to move all your desired data from one cell to another. And, the final result should look like this.

Moved Data from One Cell to Another Through Cut and Paste


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.

Press Ctrl + X to Cut Data

  • Afterward, click on cell F4 and press Ctrl + V.

Keyboard Shortcut to Paste Data

As a result, your task will be accomplished. And, for example, the outcome should look like this.

Moved Data from One Cell to Another Through Keyboard Shortcuts in Excel


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.

Using Insert Tool to Move Data from One Cell to Another in Excel

  • As a result, the Insert window will appear.
  • Subsequently, choose the option Shift cells right option and click on the OK button.

Insert Window

As a result, you will be able to move the selected data to your desired locations. And, the outcome should look like this.

Used Insert Tool to Move Data from One Cell to Another in Excel


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.

Access the Visual Basic Tool

  • As a result, the VB Editor window will appear.
  • Following, go to the Insert tab >> Module option.

Insert a Module to Move ata from One Cell to Another in Excel

  • 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.

VBA Code to Move Data from One Cell to Another in Excel

  • As a result, a Microsoft Excel window will appear.
  • Following, click on the No button.

Microsoft Excel Window

  • 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.

Save As Dialogue Box

  • Afterward, go to the Developer tab again and click on the Macros tool.
  • As a result, the Macro window will appear.

Access the Macros tool

  • Following, choose the MoveCellData macro and click on the Run button.

Run Macro to Move Data from One Cell to Another in Excel

Thus, you will see cells E4:E16 shifted to F4:F16.

Moved Data from One Cell to Another Through VBA


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.

Choose the Copy Option

  • 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.

Choose Paste Option

As a result, you will be able to acquire your desired result. And, the outcome would look like this.

Copied Data from One Worksheet to Another


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!

Maruf Islam

Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

4 Comments
  1. 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.

  2. 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

Leave a reply

ExcelDemy
Logo