I have over 16000 rows & it treats it like 2 tables???

[Rows and more rows!]

I can't sort all the information of format the enitre table a a whole. It is
treating it as two seperate tables on one sheet. When I select the entire
document, it will not allow me to sort at all. i can only sort the first 5975
and then I have to put the cursor in another row below those and then sort
again. All of the information in this sheet has been pulled copied and
pasted from several different spreadsheets.

Help to me to have one sheet with one table of information that can have all
the same properties and commands applied at the same time as a whole.
Thank you.

 

[Bill Sharpe]

I can't sort all the information of format the enitre table a a whole. It is
treating it as two seperate tables on one sheet. When I select the entire
document, it will not allow me to sort at all. i can only sort the first 5975
and then I have to put the cursor in another row below those and then sort
again. All of the information in this sheet has been pulled copied and
pasted from several different spreadsheets.

Help to me to have one sheet with one table of information that can have all
the same properties and commands applied at the same time as a whole.
Thank you.

Is there a completely blank row separating the two parts of your table?
If so, you need to delete it.