Accelerate copy and move tasks within cells and worksheets

- [Instructor] There are numerous methods and techniques…in excel for copying and moving data.…A lot of people think of copy…as being a two step operation,…we copy data, then we paste it.…And the same thing with move.…Often as described as we cut the data and then we paste it.…In this worksheet called sales in our chapter six workbook,…there's some formulas in row eight.…Here's one of em', I'll double click on cell b eight.…We can see the formula…and all the formulas to the right do the same kind of thing.…Now, we like to move this data,…let's say down into row 10.…

Let's select the data first,…and rather than cutting and pasting this,…why not simply drag an edge?…Any edge. Right edge, bottom edge.…As we drag, we can put it over there,…down here, to the left, wherever.…The concern could be if you've never done this,…how about the formulas?…What's going to happen to them?…Well, fortunately, excel knows what to do here.…As we drag here, and let go of the mouse,…we see the same numbers down here.…The formulas that used to refer…