Sorting question

  • Thread starter Thread starter arkum
  • Start date Start date
A

arkum

When i sort I can only choose up to three columns in the sort dialo
box.
Is there any way to increase this
 
No, but you can resort after the first sort. For example, if you sort 50
rows by 3 columns, you might find that the first 25 are all of a certain
value or range. You can then sort these 25 further, if you wish.
 
Hi
no but a workaround would be:
- start with the last columns and sort them first
- continue with the other columns
 
You must log in or register to reply here.

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

writing a sort macro 2
Sorting columns with locked headers in Excel 07 1
Sort Contiguous Columns - Danger 3
How to sort entire spreadsheet by one column sort 5
Sorting issue with frozen panes 11
Advanced Sort Question 1
excel is only sorting some columns - please help 5
question on sorting ? 2

Back
Top