Mon 8 Dec 2008, 15:57Delegate Dagmar said...
Dagmar has attended:
Excel Introduction course
Excel Intermediate course
Sorting
how do you sort a table of data by one of its columns? eg names
Tue 9 Dec 2008, 10:17Trainer Pete said...
RE: sorting
Hi Dagmar,
Thank you for your question;
In answer; If your table is laid out with each column having a field header, and relevant data below the header, you should format the header slightly differently from the data below (ie bold is sufficient) then click in the column you wish to sort, in your case Names and on the standard toolbar click one of the sort buttons (sort ascending or sort descending). If you table is constructed correctly with no gaps between headings and data it will sort the column and maintain data in the rows correctly. I hope that has helped ...Pete
