Add text and data

Move or copy cell contents

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

You can use the Cut, Copy, and Paste commands to move or copy cells or their contents.

Move cells
  1. Select a cell or a cell range.

  2. Select Home > Cut Cut or press Ctrl + X.

  3. Select a cell where you want to move the data.

  4. Select Home > Paste Paste or press Ctrl + V.

Copy cells
  1. Select a cell or a cell range.

  2. Select Home > Copy Copy or press Ctrl + C.

  3. Select a cell where you want to copy the data.

  4. Select Home > Paste Paste or press Ctrl + V.

By default, drag-and-drop editing is turned on so that you can use the mouse to move and copy cells.
  1. Select the cells or range of cells that you want to move or copy.

  2. Do one of the following:

    • To move a cell or range of cells, point to the border of the selection. When the pointer becomes a move pointer move pointer , drag the cell or range of cells to another location.

    • To copy a cell or range of cells, hold down Ctrl while you point to the border of the selection. When the pointer becomes a copy pointer Copy Pointer , drag the cell or range of cells to another location.

Move cells between existing cells
  1. Select a cell range.

  2. Hold Shift and when the pointer becomes a move pointer move pointer , drag the cell range to the new location between existing cells.

Want more?

Discover more courses like this at LinkedIn Learning

Move or copy cells

In this worksheet, this is a projection for the year 2016.

And we see some numbers here.

We might want to experiment with these and have another copy of this same layout with formulas down below.

Using the slider bar in the lower right-hand corner, I'm gonna zoom back a little bit, we've got other data off to the right that we'll get to. I'd like to copy this data down to Row 17.

Now, a familiar technique for a lot of people is to copy this data and then paste it.

And there's certainly nothing wrong with that.

And there are any number of different ways to do this.

We've got buttons here on the Home Tab.

Some people are familiar with CTRL+C to copy.

CTRL+V to paste, you can certainly do that. But you can also drag data.

And often that's gonna be the fastest. I simply want to copy this data down in Row 17.

Now, if I wanted to move it, based on the layout we're seeing that's probably not likely, but I can, after selecting the data, simply drag any edge. Drag it down here. I've moved the data.

I didn't really wanna do that though so I'll press CTRL+Z. But that's very easy to do.

And often, it's gonna be the fastest way unless you're moving the data, for example, hundreds of rows or columns downward or rightward.

If we like to make a copy of this, we do almost the same thing but we hold down the CTRL key.

You don't have to hold it down immediately, but as you're holding it down, eventually, you'll see a tiny little plus that accompanies the arrow as you drag this.

Drag it down to here. Be sure to let go of the mouse first.

We've made a copy of it. And the formulas up here, as I zoom back a little bit. Again.

The formulas up here for example, that deal with Rows 4 and 5, are automatically copied down here so that they're dealing with data in Rows 19 and 20.

So, we don't worry about our formulas as we do this.

We've made a copy of it. And maybe we're experimenting with some different numbers here in our projections.

That could be one of the reasons for copying the data.

In Excel, you can insert, in other words move and insert at the same time.

Now, if you don't know the shortcut, what you can do here is right-click Row 10, add a new row, move the data up then get rid of the empty row and sum.

Might take a little bit of time. Now, what we're about to do, we could do for an entire row.

However, there's data off to the right. We don't want to disturb that.

So, we'll simply highlight these cells right here.

And if we'd like to move them upward, all we've got to do is to drag the top edge here with the Shift key held down. Drag it up to there. Let go of the mouse first. We've moved the data.

All of our formulas get readjusted properly where necessary. Everything is working just fine.

And we can do this with column data as well. Either entire columns or just cells.

We've decided, for whatever reason, it's gonna make sense to put the department to the left of the building.

So, we click the column for Department. The entire column this time.

We will be dragging the left edge with the Shift key held down.

Drag it leftward to here.

Let go of the mouse.

And we've done that.

Learning doesn't stop here. Discover more expert led tutorials at LinkedIn Learning. Start your free trial today, at linkedin.com/learning.

Enjoy one month of free access to LinkedIn Learning

Learn from recognized industry experts, and get the business, tech, and creative skills that are most in demand.

Benefits
  • Get unlimited access to over 4,000 video courses.

  • Receive personal recommendations based on your LinkedIn profile.

  • Stream courses from your computer or mobile device.

  • Take courses for every level – beginner to advanced.

  • Practice while you learn with quizzes, exercise files, and coding windows.

  • Choose a plan for yourself or your entire team.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×