Can someone tell me how to move a column in excel 2007? I've been highlighting the cell, choosing 'cut' and inserting the cells at my chose place, but all i get is a message that says I can't perform the action on multiple selections.



This is driving me crazy!

you can select different cells, but you cannot use cut function, you can only use copy-paste selection, but you can select again the cells and delete, move cells up.
Or you can use a macro, to do this. You can start with this:

Sub CopyPasteDelete()

Range("D8,D9,D13,D17").Select
Selection.Copy
Range("H8").Select
ActiveSheet.Paste
Range("D8,D9,D13,D17").Select
Selection.Delete

End Sub

I found this page helpful in terms of moving columns in Excel - especially since I'm using the MAC version of excel:

http://www.programmerinterview.com/i...lumn-in-excel/