MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sort Warning for a single column


Posted by thomas venn on February 24, 2000 1:50 PM

Hi,
When I need to sort a single column, and there is data in adjacent cells, Execl gives me the following warning: " SORT WARNING Microsoft Excel found data next to your selection. Since you have not selected this data, it will not be sorted. What do you want to do? [] Expand the selection or [] Continue with the current selection".

Well, I know what I am doing, and all I want to do is sort a single column. Is there anyway to disable this stupid warning message? Thanks for all your help.

Regards,

Thomas


Posted by Celia on February 24, 2000 5:11 PM

Thomas
The Data toolbar has two buttons called Sort Ascending and Sort Descending. These will sort your column without displaying any warning message.
Celia

Posted by Thomas Venn on February 25, 2000 11:01 AM

Hi Celia, Thanks for the tip, but it is not what I need. What I want to know is if there is anyway to disable the warning all together, because rarely do I use the two sort buttons. I always use Data->Sort...

Thanks,

Thomas

Posted by Celia on February 25, 2000 4:48 PM

Thomas
Sorry, I don’t know how to turn off the warning.
When you do single column sorts, why would you want to use the “Data>Sort…” command ?
The Sort Ascending and Sort Descending buttons are better in that only one click is required.
Celia


Posted by Thomas Venn on March 01, 2000 11:39 AM

Hi Celia, Thanks for trying. When I sort, I usually have a lot of data in many columns, and I need to sort different columns within the spreadsheet for analysis. So I highlight the entire spreadsheet, then pick the column to sort.

Regards,

Thomas