Adrian, Remember to select the data that you want to sort first and be aware that it tends to sort the data in complete rows. This is normally fine but, for instance, if you have a second table to the right of the first, it may not be what you want. In the sorting dialogue box you get the chance to sort by up to 3 columns and you can set each one to either be ascending or descending. Another issue to keep an eye out for is whether you have a header row or not - it's all pretty obvious once you get to the dialogue box for sorting but it's quite an important detail to be aware of. Finally, remember that you can always use the Control+Z keystroke to undo a bungled sort to get you back to where you came from. All the best, Jamie -----Original Message----- From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx] On Behalf Of adrian.rowe Sent: 25 January 2011 19:21 To: jaws-uk@xxxxxxxxxxxxx Subject: [jaws-uk] Re: question about XLS files Thanks David, I'll give that a try. Adrian Rowe Email: adrian.rowe5@xxxxxxxxxxxxxx Skype Name: rubberdingey ----- Original Message ----- From: "David Wood (G3YXX)" <david.g3yxx@xxxxxxxxxxxxxx> To: <jaws-uk@xxxxxxxxxxxxx> Sent: Tuesday, January 25, 2011 6:26 PM Subject: [jaws-uk] Re: question about XLS files > Enter the data in whatever order you want. > > At an appropriate time go to "data" (alt+d). > This will put you onto "sort" - enter on it > Tab around and you will find ascending. Enter on it and job done. > > > -----Original Message----- > From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx] > On Behalf Of adrian.rowe > Sent: Tuesday, January 25, 2011 5:58 PM > To: jaws-uk@xxxxxxxxxxxxx > Subject: [jaws-uk] question about XLS files > > Please can anyone help with this question? > > I have just started a new XLS file. However, I would appreciate if anyone > could tell me how I can keep items in the first column in alphabetical > order. As and when I insert new items to the list, they will not be > necessarily IN alphabetical order. > > I would appreciate any kind of help. > > With Many Thanks, > > Adrian Rowe > Email: adrian.rowe5@xxxxxxxxxxxxxx > Skype Name: rubberdingey > > > > -- > I am using the free version of SPAMfighter. > We are a community of 7 million users fighting spam. > SPAMfighter has removed 1566 of my spam emails to date. > Get the free SPAMfighter here: http://www.spamfighter.com/len > > The Professional version does not have this message > > > ** To leave the list, click on the immediately-following link:- > ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] > ** If this link doesn't work then send a message to: > ** jaws-uk-request@xxxxxxxxxxxxx > ** and in the Subject line type > ** unsubscribe > ** For other list commands such as vacation mode, click on the > ** immediately-following link:- > ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq] > ** or send a message, to > ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq > ---------------------------------------------------------------------------- ---- No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.449 / Virus Database: 271.1.1/3402 - Release Date: 01/25/11 07:34:00 ** To leave the list, click on the immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** jaws-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq __________ Information from ESET Smart Security, version of virus signature database 5818 (20110125) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 5818 (20110125) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 5818 (20110125) __________ The message was checked by ESET Smart Security. http://www.eset.com ** To leave the list, click on the immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** jaws-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq