First, highlight the entire section of the spreadsheet that contains your
list. Then, click on the "Data" drop down box and you will see an option
called "Sort". Click on that and a box will pop up that will give you
options as to which column to sort by. Choose the Supplier Name column to
sort by and click on the "Ok" button and your list will be sorted
alphabetically by supplier name.


--
Scott


"lianeanddave" wrote:

i have 100 rows and i have i have 8 columns 1 with newspaper name 6 with
dates that we are missing the voucher copy for and 1 with supplier name i
need to put the supplier name into alphabetical order but i need it to move
the newspaper name and date columns as well so that they all will be correct
if anyone can help asap i would be most grateful many thanks