Select the entire range (all the columns that should be kept together).

Then Data|sort


DarkChylde wrote:

I guess a better wording for my question using kamchatka1's scenario. I
have a list with 2 columns, one with last names, and one with first
names. I depending on the situation I want to sometimes sort by first
name, sometimes by last name, but always keep their last name and first
name next to each other.

--
DarkChylde
------------------------------------------------------------------------
DarkChylde's Profile: http://www.excelforum.com/member.php...o&userid=28728
View this thread: http://www.excelforum.com/showthread...hreadid=484190

--

Dave Peterson