PDA

View Full Version : Number of sorts allowed in XL2007



Barryj
04-10-2009, 09:07 AM
I want to record a macro to sort columns B2 to W31, with names in column A, I think in 2003 you could only sort 7 columns.

Does anyone know if 2007 allows you to sort more columns than 7?

Zack Barresse
04-11-2009, 01:03 PM
You could only sort 3 columns in 2003, unless you used a helper column with formulas, and 2007 has 64 (and you can also use helper columns for an exponential number).

See here for 2007 limits:
http://office.microsoft.com/en-us/excel/HP100738491033.aspx

HTH

Barryj
04-11-2009, 01:55 PM
Thanks Zack, I was hoping it would be much better than 2003, I will continue on with my project now I have that good news!