Why can't I sort new Excel entries after I exceed 1115 lines?

G

Guest

I am trying to sort alphabetically a list of first and last names. It sorts
perfectly until I exceed 1115 lines. Additional entries are not sorted but
are left in the order entered. Is there a limit on the number of rows or do I
have another problem?Thanks-Merv
 
R

Ron Coderre

When I select the range to be sorted...then sort...the entire range sorts.

So, just guessing here....
Are you letting Excel figure out the range to be sorted?
and does that range have a blank row in it?
AND does the sorting stop at that blank row?

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 

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

How can I save a sort order for re-use instead of having to type i 1
The last two entries in a range won't sort 2
Sort confusion 2
Excel Pivot Table - Sort Report Filter Values 3
Row height adjustment after sort 2
Sort problem in Excel 2007 3
macro to delete lines based on a value - Repost 2
Why the arbitrary spreadsheet size limitations? 7

Top