Sorting Columns

I have a bunch of data in an Excel spreadsheet and need to alphabetize one of the columns. However, the non-alphabetized data correspond to data in adjacent columns. Is there any way I can alphabetize the first column and move the corresponding data in the other columns to match that data in the first column? Thanks.

Select both columns when you sort.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Zapvet" <Zapvet.29an4n_1150123202.0694@excelforum-nospam.com>
wrote in message
news:Zapvet.29an4n_1150123202.0694@excelforum-nospam.com...
>
> I have a bunch of data in an Excel spreadsheet and need to
> alphabetize
> one of the columns. However, the non-alphabetized data
> correspond to
> data in adjacent columns. Is there any way I can alphabetize
> the first
> column and move the corresponding data in the other columns to
> match
> that data in the first column? Thanks.
>
>
> --
> Zapvet
> ------------------------------------------------------------------------
> Zapvet's Profile:
> http://www.excelforum.com/member.php...o&userid=35331
> View this thread:
> http://www.excelforum.com/showthread...hreadid=551020
>

Thanks a ton!