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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting hidden columns 6
Sorting Column A & Include date in the Entire Row 2
Print Macro 7
Sorting several columns 1
How to sort entire spreadsheet by one column sort 5
Sort Issue 2
Sorting and Formulas 1
Using Filter more than once 2

Back
Top