2
I have a very basic worksheet with multiple columns and rows. I usually will sort one column to sort a-z and normally all data for those rows would follow the sort. Suddenly I am finding that if I sort one column, the remaining columns do not sort, even though I choose the "Expand The Selection". I have also noticed that after sorting, the worksheet is split into one set of columns on the left side that did sort, another set of columns on the right did not follow the sort. It is split. I have about 45 columns and 150 rows so the worksheet is particularly large.
Completely befuddled.
Dud you tried adding autofilter to the range and sorting by that? Did you tried converting your range to a table (insert - table)? Why you added worksheet-function tag? – Máté Juhász – 2015-12-20T18:14:03.173
copy and paste(data only) into a new spreadsheet and work on that – codemonk113 – 2015-12-20T21:31:41.847
1Thanks for the suggestions to both of you. I tried Máté's suggestion for autofilter and that worked. Elementary, I know.. but excel not my forte. – Reuben Cano – 2015-12-20T22:05:19.540