Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to move data in Excel

How to move data in Excel

Transcript 

In this lesson, we'll look at how to move data from one place to another in Excel. The most common way to move information is to use cut and paste. We'll cover three options: using buttons on the ribbon, using keyboard shortcuts, and using the right-click menu.

Let's take a look.

The most basic way to move content in Excel is to select one or more cells, then click the "cut" button on the ribbon, move to another location, and click the "paste" button on the ribbon.

When you cut content, notice that Excel doesn't immediately remove the content.  Instead, the cut data is highlighted by a moving dashed line—sometimes called "marching ants." This indicates that the cut information is on the clipboard and ready to move to a new location.

If you decide you don't want to move the data after all, just press the escape key and the marching ants will disappear.

In addition to the buttons on the ribbon, you can use the keyboard shortcuts for cut and paste. Control-x to cut; control-v to paste.

You can also right-mouse click to cut and paste.

Finally, you can move entire rows and columns using cut and paste. Just make sure to select the column letter or the row number to get a complete selection.

Because columns and rows are very big objects, be sure you don't accidentally overwrite important information elsewhere on the worksheet.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
This is fantastic. I am working on a report and this is exactly what I needed. Thanks.
Diane
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page