Sorting Columns

[Mike]

I am trying to prevent sorting of columns without sorting
all of the columns. Each row contains information that
can not be mixed up when sorting by columns.

 

[Vasant Nanavati]

I don't think you can do this without using a fairly complex macro.

 

[Guest]

I sort data columns all the time where I don't want the
adjacent data to sort. Not sure what version of excel
you're using, but mine will ask if I want the data beside
sorted with it or not. And if there is an empty column
on either side of the column I want sorted, no other data
will be touched when sorting.

 

[Vasant Nanavati]

I think the OP wants to force all the columns to sort.