Offer a feature to disable the sort warning in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is just a suggestion to MS. Feel free to add your opinion if you wish.
Excel should offer a feature to allow experienced users to disable the sort
warning in Excel 2003 that pops up everytime you select a range that has info
in any of the cells contiguous with that range.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...2-0eddb65208e4&dg=microsoft.public.excel.misc
 
And not just the sort warning for adjacent data found, but also the sort
warning for "numbers and numbers stored as text". These should be
independently set. I am working with a worksheet that has, for example, zip
codes, with leading zeroes. In order to preserve the leading zeroes I must
either put in some funky custom formatting (which I don't want to do) or I
just make the column text. Usually when I am working with this sort of thing,
I don't care if these columns sort as numbers or as text, because I am doing
data cleanup where I am more interested in grouping and unusual values than
in the exact order.

I can't tell you how many times the "new features to help those poor stupid
Office users do their work better" have resulted in total aggravation for me,
someone who DOES know how to use software. I don't want my hand held. I don't
want to be taken places I don't want to go. And I don't want 'help' coming up
EVERY SINGLE FNOODLING TIME I'm doing something in my normal workflow,
requiring me to answer stupid questions when I want to work smoothly and
efficiently.

For what it's worth, I like the warning about adjacent data when I'm
sorting. But one should always have the ability to turn off warnings and
features one doesn't like.

-ESquared
 
I think ALL warnings should be capable of being toggled. There are times
when a warning is nice, and there are times when a warning is just a pain.
 
I am doing 3 clicks where I should only have to do one so it is increasing my
work time 200% (actually more because I then have to move the mouse to the
right area to click) and it is driving my nuts (not to mention playing havoc
with my arthritis). I have dozens of columns that each have to be sorted
indepently and to not be able to turn this annoying prompt off is making me
want to find other software.
 
While waiting for the developers to comply, do you want a single-click on a
button macro that sorts only the selected column?

Sub sort_selected_column()
Dim srng As Range
Set srng = Range(ActiveCell, Cells(Rows.Count, _
ActiveCell.Column).End(xlUp))
srng.Sort Key1:=Range(srng.Cells(2).Address), _
Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=2, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub


Gord Dibben MS Excel MVP
 
Back
Top