Mac – How to move columns with drag and drop in Excel 2016

Answered by deargeek.net:

1. Select the Column or Row you want to move
2. Move your mouse pointer up to the blue edge of the selection until it changes from a cross to a regular pointer arrow or hand. Note: The mouse pointer must be on one of the highlighted cells and not on the row or column headings.
3. Hold down the shift key and click and drag the column/row to the new position. A faint “I” bar that runs the entire length of the row or column, along with a box indicating where the new row or column appears.
4. Release the mouse button and then leave the SHIFT button, and your row or column is moved.

I have verified this with Excel 2011 (14.0.2) running in Mac OS 10.6.7.

For now, at least, you need to do this with the OS X System Preferences -> Keyboard -> Shortcuts feature. This only works for commands that are available on the application's menus.

I was able to create shortcuts this way for my two most frequent functions, Insert Rows and Delete Rows. The menu item for Insert Rows is called "Rows". It's on the Insert Menu, but you just enter "Rows" in the shortcut. The menu item for Delete is Delete in the Edit menu, so just enter "Delete". This isn't the same as "Delete Rows", which is not available on the menu so I need to select a row with Shift-Space before deleting it.

I'm hopeful they will restore this feature in the future.