software

I am new to excel and would like some advice please.

I am treasurer for a forthcoming concert. All the seats are numbered in the
concert hall. As the bookings come in the customer is allocated a seat and
his name is recorded in column quot;Aquot; of excel with the seat number in say
column quot;Dquot;.

I wish to sort the names into alphabetical order and at the same time move
the seat number allocated to them in quot;Dquot; as well.

Could I ask some kind soul to advise me please. If I'm in the wrong group I
apologise and hope someone will point me in the right direction

Neville
You need to highlight ALL the data before you sort. Assume your data
occupies A1 to F100, then that is the range you should highlight, then
click Data | Sort and you will be presented with a dialogue box - you
can specify which field to sort on (in your case column A) and whether
you want the sort to be in ascending or descending order. Click OK once
you have set everything, and your data will be sorted correctly.

Avoid using the sort icons on the toolbar.

Hope this helps.

PeteThanks Pete,

Simple when you know how!!

Sorry for the typo in the heading.

Neville
quot;Petequot; gt; wrote in message oups.com...
gt; You need to highlight ALL the data before you sort. Assume your data
gt; occupies A1 to F100, then that is the range you should highlight, then
gt; click Data | Sort and you will be presented with a dialogue box - you
gt; can specify which field to sort on (in your case column A) and whether
gt; you want the sort to be in ascending or descending order. Click OK once
gt; you have set everything, and your data will be sorted correctly.
gt;
gt; Avoid using the sort icons on the toolbar.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;