Rearrange Items in Excel by Dragging and Dropping

Excel is one of the most powerful programs in the Microsoft Office suite — and for many users, it’s also one of the most intimidating. Let’s face it, a lot of the capabilities that really help you make Excel into a lean, mean, productivity machine, like macros and formulas, just aren’t intuitive. However, Excel still offers a lot of quick, drag-and-drop features that make simple operations a lot easier. 

For example, let’s say you have a short list of office supply items:

item1

If you want to rearrange the list and insert Stamps between Adhesive and Paper, you might highlight the row, copy it, click on row 3, and select Insert Copied Cells. But there’s an even faster way to do it that doesn’t involve drop-down menus.  Just highlight the cells you want to move, grab the top of the selection border, and hold down the Shift key.

item2

 

You can then drop them into place and all the cells below will automatically move down.

item3

 

If you don’t hold down the Shift key, Excel will ask you if you want to replace the contents of the selected cells. And if you hold down the Ctrl key, Excel will automatically perform a copy of the selected cells.

 

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: