How do you sort a multi-column list by rows?

[KreiderM]

I'm a worship leader, I need to create an index for the songs in my notebook.
I'm using Excel (I'm an absolute beginner, just got it yesterday) and need
to know how to sort a list with several columns (song title, tempo etc.) by
any one of the columns and keep the rows intact. Thanks 4 the help.

 

[Jani Kärkkäinen]

If I understood your problem correctly, this should help, at least a bit.

Select ONE cell in the column you want to sort by. Then click on a button in
the toolbar, it should say AZ and an arrow downwards. To do an ascending
sort, click the button with and arrow upwards.

If you don't see any of the buttons, try the Sort dialog. You can get that
by going to the menus, Data->Sort

Hope this helps.

 

[Gord Dibben]

Excel sometimes has a hard time guessing what needs to be kept together.

Pre-select all the columns you want sorted then Data>Sort. Do not use the A/Z
button.

Gord Dibben Excel MVP