From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,700 courses taught by industry experts.

Use dragging techniques for faster Paste Special options

Use dragging techniques for faster Paste Special options - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use dragging techniques for faster Paste Special options

“

- [Instructor] Excel has numerous options available 2 when you're copying and moving data. 3 If it's a simple move, let's remind ourselves 4 that if we wanted to move that data 5 that's up in rows 1 through 7 on this worksheet, 6 highlight the data, point to any edge, 7 drag this wherever we want it to be. 8 Now, if it's a copy, 9 I'll press Ctrl + Z to undo what I just did. 10 We can point to any edge and drag using the Ctrl key. 11 You don't have to hold it down right away. 12 So, we don't need any special menus here. 13 Ctrl drag it's sometimes it's called. 14 Sure to let go of the mouse first. 15 Now, I want to undo that, Ctrl + Z. 16 What I really want to do now 17 is transpose this data so it's highlighted, 18 I'll press Ctrl + C, 19 click on cell A10 and now paste special 20 by way of Ctrl + Alt + V. 21 Handy keystroke shortcut. 22 You see it depicted in that blue shadow box in column O. 23 We'll simply…

Contents