+ Reply to Thread
Results 1 to 2 of 2

Sorting created lists by name and color

  1. 12-07-2011, 04:13 PM #1
    rikarubin
    rikarubin is offline
    Registered User
    Join Date
    12-07-2011
    Location
    waltham, MA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Wink Sorting created lists by name and color

    Is it possible to create a drop down list in multiple columns and then after you enter a name for example, to be able to sort those names in the column? I have been trying to do this and have not been able to make it work in multiple rowns in a column.

    I would appreciate any advice or let me know if this is not possible. Or if there is a way to do something similar in another way that I have not thought of yet. Also, is it possible to create conditional formatting so you can assign each name in the list a color?

    Thanks
    Reply With QuoteRegister To Reply
  2. 12-08-2011, 02:18 AM #2
    Dirigo
    Dirigo is offline
    Registered User
    Join Date
    10-02-2011
    Location
    Los Angeles, USA
    MS-Off Ver
    2010 Home Version (doesn't include Access and Outlook )
    Posts
    22

    Re: Sorting created lists by name and color

    I don't have excel 2003, but I assume you can use the data validation tool under the Data heading. This tool invites you to create a list to fill cell values in the selected column. You can input the list values manually or refer the list to a range.

    The easiest way to sort a column is (again in the data tab) to click on data filter. The menu will invite you to sort column according to its data type, i.e., youngest to oldest, numerically, alphabetically, etc.

    It could be I'm misunderstanding your question. If so, I apologize.
    Last edited by Dirigo; 12-08-2011 at 02:28 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1