Hi,

How can I switch data between cells, rows or columns in one step? For
instance, if I want to switch the contents of cells A1 and B1, how do I
do that without having to retype everyting, and without having to use a
third column (that's what I do now: first I copy B1 to C1, then A1 to
B1, then C1 to A1, then delete C1 - this method is obviously very
tedious...).

Tnx,
John


--
jonnel
------------------------------------------------------------------------
jonnel's Profile: http://www.excelforum.com/member.php...o&userid=36946
View this thread: http://www.excelforum.com/showthread...hreadid=566598