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
From the course: Excel 2016: Tips and Tricks
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.