Results 1 to 4 of 4

Thread: Help Pls

  1. #1
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183

    Red face Unanswered: Help Pls

    Hi Everone.

    I'm trying to crate spreadsheet to keep track of my music collection. I want to keep track by "Artist" "Album" and "Songs"

    Is it possible when i sort it by "Artist" the song and album which is belongs to "Artist" will also be sorted ? If not, any other suggestion ?

    Thanks in advance
    Skharva

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067

    Re: Help Pls

    Excel usually sorts all the data in a list automatically
    the Exception occurs when there is spaces between the data
    i.e. missing rows or columns.

    you can get round this by selecting all the data you want to sort
    then everything will be sorted.

    HTH

    David

  3. #3
    Join Date
    Mar 2004
    Location
    Minnesota, USA, Earth
    Posts
    65

    Auto Filter

    Hi,

    You might also want to try Auto Filter. It won't sort your data, but it can filter out rows for artists you're not looking for.

    Before you set-up auto filter, make sure that there are no blank rows for the data range you want to filter. Next, Click on the row with the column headers (a.k.a. labels), then click on the Data Menu, Filter, AutoFilter. Little boxes with triangles will appear next to the header for each Column. Click on the little box for the column you want to filter. The box will show you all the values that are in that column and clicking on one of these will hide all the rows that do not meet your selection. Clicking on the little box again and selecting (All) will restore your list back to displaying every row.

    Hope this is helpful,

    -Mike

  4. #4
    Join Date
    Nov 2002
    Location
    Oakland, CA
    Posts
    126
    Use ITunes

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •