Make sure you select the entire range to sort first. Then Data|Sort that range.

If you let excel guess at the range to sort, it may not guess what you want.

Patlee wrote:

In sorting specified columns by hiding unwanted columns, Excel sorts as
requested but stops sorting about 20 lines before the end of the worksheet,
leaving those 20 lines unsorted. How to get the entire worksheet sorted?
Thanks.

--

Dave Peterson