From the course: Excel 2019 Essential Training

Unlock the full course today

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

Moving, copying, and inserting data

Moving, copying, and inserting data

From the course: Excel 2019 Essential Training

Start my 1-month free trial

Moving, copying, and inserting data

- [Instructor] No matter how a worksheet looks, you can easily change its appearance by making a copy of data, sometimes you want to move data. And at other times, you actually want to move and insert data at the same time. On this worksheet called Move-Copy-Insert, in the workbook 05 - Layout, we've got two sets of data. And for the information on the left-hand side here, I like the look of it, except I want to move this portion of it, as I click and drag across, I wanna move this down a row or two. Although you can use traditional cut and paste methods, often, moving data is simply a one-step process after you select the information. Highlight the cells you want, drag an edge. You can drag any edge, example here, I'll drag the right edge down, let go of the mouse. Everything has been moved down. There are formulas in this list. There's a formula here, for example, we didn't look at it earlier, now it says, you can see in the formula bar, C5 minus C6. Formulas adjust automatically…

Contents