excel unsort
 

Excel has the buttom to sort the columns. I would like to see a button to do
the opposite and scramble the items in a column into a random order. I am a
college student and I use excel to make lists to study from. It would be more
effective if I could scramble the order of the cells. (i.e, vocabulary words
and defenitions, etc.)

----------------
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/comm...et.f unctions

How about sorting by an added random number column?

"Cheffred" wrote:

Excel has the buttom to sort the columns. I would like to see a button to do
the opposite and scramble the items in a column into a random order. I am a
college student and I use excel to make lists to study from. It would be more
effective if I could scramble the order of the cells. (i.e, vocabulary words
and defenitions, etc.)

----------------
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/comm...et.f unctions

Add a column to your rows with =RAND() in it. then, sort by that column. It
should randomize your list well enough for what you seem to be looking for.

--
tj


"Cheffred" wrote:

Excel has the buttom to sort the columns. I would like to see a button to do
the opposite and scramble the items in a column into a random order. I am a
college student and I use excel to make lists to study from. It would be more
effective if I could scramble the order of the cells. (i.e, vocabulary words
and defenitions, etc.)

----------------
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/comm...et.f unctions