is it possible to swap cells without having to cut and paste? if i have data
in b3:b5 and c3:c5, and i want the data in each column to switch, is there a
function that allows me to do that?

Not without resorting to a macro

Right click the sheet tab, view code and paste this in and run it

Sub swap()
Range("B3:B5").Copy
Range("A65534").PasteSpecial
Range("C3:C5").Copy
Range("B3").PasteSpecial
Range("A65534:A65536").Copy
Range("C3").PasteSpecial
End Sub

Mike

"scott" wrote:

> is it possible to swap cells without having to cut and paste? if i have data
> in b3:b5 and c3:c5, and i want the data in each column to switch, is there a
> function that allows me to do that?