How to omit a column during sorting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 9 columns of data (A to I). How to I sort columns B to I and leave
column A as is? The sort criteria will be selected from one of the columns B
to I.
Alex.W
 
Select your range (B1:I###) and then use Data|Sort.

Depending on the version of excel you're using, you may get prompted to expand
the range to sort. Tell excel no!
 
Thanks Dave.
Alex.W

Dave Peterson said:
Select your range (B1:I###) and then use Data|Sort.

Depending on the version of excel you're using, you may get prompted to expand
the range to sort. Tell excel no!
Click to expand...
 
Back
Top