From the course: Excel 2016: Tips and Tricks

Unlock the full course today

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

Accelerate copy and move tasks

Accelerate copy and move tasks

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Accelerate copy and move tasks

- [Voiceover] One of the most common kinds of data manipulation you use in Excel is copying data or moving data. And although the process can be a two step process, we can move data by cutting and pasting, we can copy data by copying and pasting, and sometimes, those techniques are appropriate. At other times, it's gonna be a lot simpler and faster simply to use the mouse to drag data. Simple example here. I've got some information. I want this to be farther down on the sheet. I've got it highlighted. I'll just drag any edge. Maybe the bottom edge. I need it down at row 10. I'll just drag it down there. Could hardly be simpler or faster. I'll change my mind. I'll move it back up here to row two. Easily handled. I might have totals in here. I don't just yet, so I'll highlight these cells I'm using the Ctrl key to highlight these, and a nice shortcut, Alt+=, put in totals there. I'll readjust the column widths, click in the upper left corner, double click any column boundary, and there…

Contents