excel training course london - Colums

Hi Leyla

I think the Sort feature and Filter feature would do what you describe.

Before you use either of these features, your spreadsheet should be set up so each column has a heading at the top of the column which is bolded, for example, First Name, Last Name, Address, City, Postcode.

Then once the information has been entered into the spreadsheet, you can sort the information to put it in a certain order, for example, if you wanted to have the information in alphabetical order of Last Name, you select a cell in the Last Name column, then click the Sort Ascending button on the standard toolbar (the button has a capital A and capital Z on it).

If you want to to show just the people whose last name begin with a certain letter, then you need to use a filter. If you go to Data - Filter - AutoFilter, then a dropdown arrow will appear next to each of the column headings, and you can click the dropdown arrow next to the Last Name heading.

Choose Custom Filter from the dropdown arrow. Then you can set your criteria for the filter, e.g. begins with B.

You can then use the dropdown arrow to select All and then all the information you entered into the spreadsheet originally should show.

I hope this helps. Sorting and filtering is covered as part of our Excel Intermediate course if you are interested in coming on further courses with us.

thanks
Amanda