How to Move Data from One Cell to Another in Excel – 5 Methods

Download Practice Workbook

Download the practice workbook for free!


The sample dataset contains Order Date, Product, Quantity (Pc), and Unit Price.

To move the Unit Price column (E4:E16) rightward (F4:F16).

Sample Dataset to Move Data from One Cell to Another


1. Dragging and Dropping

Steps:

  • Select cells E4:E16.
  • Place your cursor at the right corner of your selection.
  • A move cursor will be displayed.
  • Left-click and drag the selection to column F.

This is the output.

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


Method 2 – Using the Cut and Paste Options

 Steps:

  • Select D4:D16.
  • Right-click and choose the Cut option.

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

  • Click on F4 and right-click.
  • Choose Paste.

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

This is the output.

Moved Data from One Cell to Another Through Cut and Paste


Method 3 – Using Keyboard Shortcuts to Move Data from One Cell to Another

Steps:

  • Select the cells you want to move (E4:E16 here).
  • Press Ctrl + X.

Press Ctrl + X to Cut Data

  • Click F4 and press Ctrl + V.

Keyboard Shortcut to Paste Data

This is the output.

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


Method 4 – Using the Insert Cells Command

Steps:

  • Select E4:E16.
  • Go to the Home tab >> Cells >> Insert >> Insert Cells….

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

  • In the Insert window, choose Shift cells right.
  • Click OK.

Insert Window

This is the output.

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


Method 5 – Using a VBA Code to Move Data from One Cell to Another

Steps:

  • Go to the Developer tab >> Visual Basic.

Access the Visual Basic Tool

  • In the VBA Editor, select Insert  >> Module.

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

  • Module1 will be created.
  • Click Module1 and enter the following code.
Sub MoveCellData()
Range("E4:E16").Cut Range("F4:F16")
End Sub
  • Press Ctrl + S.

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

  • In the Microsoft Excel window, click No.

Microsoft Excel Window

  • In Save As, choose .xlsm in Save as type:
  • Click Save.

Save As Dialogue Box

  • Go to the Developer tab and click Macros.
  • The Macro window will be displayed.

Access the Macros tool

  • Choose MoveCellData and click Run.

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

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

Steps:

  • Select the cells you want to copy (E4:E16 here) in Sample Dataset.
  • Right-click and choose Copy.

Choose the Copy Option

  • Click E4 in the sheet you want to paste the values in.
  • Right-click and choose Paste.

Choose Paste Option

This is the output.

Copied Data from One Worksheet to Another

 

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo