From the course: Excel 2016: Tips and Tricks
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Drag and insert cells with the Shift key
From the course: Excel 2016: Tips and Tricks
Drag and insert cells with the Shift key
- [Voiceover] We're looking at a worksheet called HR List. Imagine if we want to move the status column to put it between Columns C and D, just to the right of Department. A standard technique is to right-click Column D, insert a new column, move this data over, then possibly get rid of the other empty column that we might have, but it's a lot faster if we simply drag the data with the Shift key. We can do this for entire columns or entire rows or just cells themselves. So for example here, if I want to move the status column, and there's nothing else in this worksheet below this except status entries, I'll drag the left edge with the Shift key held down. You don't have to hold down Shift immediately, but why not? So I drag it leftward here, and notice how we see this I-beam indicator. I can drag it over here, there, how about right there? I'll let go of the mouse, and I've moved the column. We can move columns left and right, we can move multiple columns. If for whatever reason…
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.