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

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

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

Use ITunes