From the course: Excel: Tips and Tricks (2023)
Join today to access over 24,700 courses taught by industry experts.
Drag and insert cells with the Shift key
From the course: Excel: Tips and Tricks (2023)
Drag and insert cells with the Shift key
- [Instructor] A great shortcut, but not so well known in Excel is the ability to move and insert in one single step. Let's imagine, on this worksheet called HR List in our chapter six file, I want the status column here to be to the left of the ID column. And the standard way to do this is to insert a new column to the left of column D, move this information over, then get rid of the empty column F. But we can do this in a single step by selecting the data, point to any edge, most likely the left edge here and hold down the shift key as we drag this left edge. And you'll see the sort of I beam separator there. Now, I can drag it anywhere I want over here. I'm going to put it between C and D and release the mouse button first and there it is. It's a simple move. I could go rightward, leftward, we can move two columns. Later, I change my mind, I want these two columns here to be to the left of column C. So I'll point to…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.