Do we have excel shortcut to switch two columns without having me to write/rec the code?

[pedie]

Hi, do we have excel shortcut to switch two columns without having me to write/rec the code?

Select and switch 2 cols [may be A with B and B with A etc]..


Thanks

 

[pedie]

Found 1 but if there is another way...pls let me know.

Select and drag style:

- Select either of the two cells
- Point at the black border
- <Shift>-drag this cell to the other side of the neighbouring cell
(You'll see a T-bar moving over tour sheet)

 

[Michael M]

Isn't it simply

Sub moovit()
    Range("RANGE").Cut Destination:=Range("RANGE")
End Sub

for cells
AND

Sub Moovit()
    Columns("COLUMNS").Cut
    Columns("COLUMNS").Insert Shift:=xlToRight
End Sub

for columns

 

[pedie]

Michael, that way, it is simple but in case if i do not want to use vba then...I thought there could be a shortcut to do that..


Thanks Mic!

 

[ogo]

You can always assign a shortcut to macro

 

[pedie]

Please tell me something better then that...just kidding...

Thanks again. I thought there is a shortcut i didn't know about

 

[Peter_SSs]

Fairly simple to ..

1. Select column B by clicking its heading label.
2. Cut
3. Select column A by clicking its heading label.
4. Right click|Insert Cut Cells