Results 1 to 3 of 3

Thread: How to shuffle a list in Microsoft Excel 2007

  1. #1
    Join Date
    Jun 2012
    Posts
    90

    How to shuffle a list in Microsoft Excel 2007

    I want some help to shuffle a list in Microsoft Excel 2007. For example I am having a list of people name. And it starts with A and end at Q. This list is alphabetically arranged. But I want to shuffle it. I cannot see any feature in Excel that can do this. I had tried looking around on the web also but it looks Excel is not having any feature like this. I want some help here. I want to shuffle the names non-alphabetically and then make a printout of the same. But I am quiet stuck with this problem. Can this be done through some other software. That can help me import the cell back in Excel later on.

  2. #2
    Join Date
    Apr 2009
    Posts
    460

    Re: How to shuffle a list in Microsoft Excel 2007

    There is a third party addon that can help you to do this. You can download and use Randomizer. There is a trail edition available. This will help you to random a list. And this appear on the top ribbon in Excel. It also has other more functions. But you will get a limited access in using the same. If you do not want this then you can try using a numerical type of arrangement. Like type a random number next to the name. For example 2,100,7, etc. And then sort through that column and the job will be done. The only thing that will consume time is typing the numbers.

  3. #3
    Join Date
    Apr 2009
    Posts
    393

    Re: How to shuffle a list in Microsoft Excel 2007

    You don't need a third party addon for the same. Or you don't really have to type numbers in each and every cell of Microsoft Excel. There is one function in Excel which will help you to get the list get shuffled easily. For that you have to type =RAND() formula next to the name. And it will give you a number. You just have to drag it to the bottom. Then sort through that column and done. Your list will get shuffled. I thin this will be the fastest way of shuffling the list you have in Excel.

Similar Threads

  1. I need help to update drop down list on Microsoft Excel
    By Tur^turro in forum MS Office Support
    Replies: 3
    Last Post: 28-01-2012, 03:57 PM
  2. How to paste data in filtered list of Microsoft Excel
    By SeanZ in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 01:00 PM
  3. Excel 2007 does not create a jump list om Windows 7
    By Samaria in forum Operating Systems
    Replies: 4
    Last Post: 16-12-2010, 10:13 PM
  4. How to add List in microsoft excel
    By Khan Baba in forum Windows Software
    Replies: 5
    Last Post: 28-12-2009, 03:02 PM
  5. Microsoft Excel VBA (macros list)
    By Samra in forum Windows Software
    Replies: 2
    Last Post: 17-01-2009, 10:04 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,710,821,889.80589 seconds with 17 queries