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

M

Merv

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

Space at end of multi page list to accommodate new entries 1
Merge Excel file into Word Document 3
Can't save my Office documents (after computer rebuild and reauthorization) 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
excel 2011 won't sort alphabetically 7
Sorting by rows with differing numbers of cell entries 3
Sorting rows 16
Why can't this table be sorted? 3

Top