From the course: Excel Essential Training (Microsoft 365)

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Moving, copying, and inserting data

Moving, copying, and inserting data

From the course: Excel Essential Training (Microsoft 365)

Start my 1-month free trial Buy for my team

Moving, copying, and inserting data

“

- [Instructor] Simple thought that occurs to us as we work with not only Excel, but also Word, PowerPoint and other software packages is this idea of I will not repeat or retype something that's already there. We often will copy data, copy information. As we look at this worksheet called Move-Copy-Insert. We might want to make a copy of this data using some different numbers. So possibly we'll highlight this portion of it. And if you have worked with other software, you're familiar with the two-step process of copy and paste. And if you're moving it, cut and paste. if I want this to also appear down in row 20, instead of copying it and pasting it, which certainly isn't wrong, I can point to any edge here and drag it. If I hold down the Control key as I do this, a tiny little plus is accompanying the arrow. As we start to drag down a little bit here, automatic scrolling occurs, get right to this location. I'll release the…

Contents