Export a sorted table to excel

1. How do I return a sorted data in Excel?
2. Why can't I sort my table in Excel?

How do I return a sorted data in Excel?

Go to Home tab > Sort & Filter > Clear to clear the sorting/filtering. This will remove all filters to sort state and get rid of sort arrows.

Why can't I sort my table in Excel?

Wrong Selection. If you select the wrong rows and columns or less than the full cell range that contains the information you want to sort, Microsoft Excel can't arrange your data the way you want to view it. With a partial range of cells selected, only the selection sorts. With empty cells selected, nothing happens.