Excel is only sorting the first 24 rows of my table

Question

After some faffing about with Excel Online simply to make a simple table so I can sort it for reference, I've spent a solid hour and a half filling data and suddenly hit a deadstop. 

I've got 91 rows in my spreadsheet and all I want to do is, simply, sort the data in those columns. There are no blank cells, not a single letter - they're all a number.

But for some bizarre reason, even if I highlight them all, Excel only sorts the first 24 rows and ignores the rest. After some googling I've not found a single solution that applies to this version of excel.

Answer 1

The data at the bottom appears to be outside of the table. Unfortunately you cannot resize a table with On line excel so try the following procedure to resolve the problem

1. Select all of your data and Copy.
2. Select a cell away from the table (with at least one clear column or row separating your selection and the table)
3. On the Home ribbon select the Paste DropDown (Don't right click because of limited Paste option.)
4. Select Paste formulas.
5. The copy of the data will now be outside of a table.
6. Press Esc to clear the crawling ants around the original copied data.
7. Select all of the original data.
8. Towards the right end of the home ribbon select the Clear DropDown and Click Clear All.
9. Now copy your previously pasted data back to the original position
10. Select all of the data and insert the table again so that the table includes all of your data.

As to how some of your data become separated from your table I do not know the answer but most likely something that you did not do correctly.

Answer 2

Thanks, worked perfectly fine - if a little roundabout.

Answer 3

Thanks, worked perfectly fine - if a little roundabout.

Yes. It is a roundabout method but the only way I know of if On Line Excel is used.

With a full copy of Excel on your computer, it is a simple matter to resize a table.