ExcelBanter - Sorting columns in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sorting columns in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/144190-sorting-columns-excel.html)

Patlee

Sorting columns in Excel

When sorting columns by hiding unwanted columns, Excel sorts as I request but
not the entire worksheet. It sorts the first 82 rows correctly but leaves
the last 20 or so lines unsorted. How can I get it to sort the entire
worsheet?

Dave Peterson

Sorting columns in Excel

See your previous post.

Patlee wrote:

When sorting columns by hiding unwanted columns, Excel sorts as I request but
not the entire worksheet. It sorts the first 82 rows correctly but leaves
the last 20 or so lines unsorted. How can I get it to sort the entire
worsheet?

--

Dave Peterson

All times are GMT +1. The time now is 10:01 PM.