From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Moving, copying, and inserting data

Moving, copying, and inserting data

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Moving, copying, and inserting data

“

- We're looking at the worksheet called Move Copy Insert in our 05 - Layout file. There certainly are times when you say, "I need a copy of this data." For example, 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 going to 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 control + c to copy, control + v to paste. You can certainly do that, but you can also drag data, and often that's going to be the fastest. I simply want to copy this data down in row 17…

Contents