How does one link cells in a single row?

[wvpvthomas]

I have a list of customers, with corresponding data in each row. However, I want to sort the customers by who spends the most money, as well as other characteristics.

Is there a way to link cells so that all the information matches up properly when sorting?

Thanks,

Adam

 

[skywriter]

If all the data is in columns that are next to each other, then when you sort Excel will keep them all together.

Data such as that below would be an example.

Excel 2010
	A	B	C
1	Cust. #	Cust. Name	Cust. City
2	123	Joe	Atlanta
3	456	Bill	Miami
4	789	Bob	Seattle
Sheet1

 

[wvpvthomas]

Thanks! I'm not very familiar with Excel, obviously. I just had to select all my desired data and then was able to sort it, so it did it all for me. Thanks!