98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course london - Colums
excel training course london - Colums
Resolved · Low Priority · Version Standard
Leyla has attended:
Excel Introduction course
Colums
I've seen a spread sheet organised to introduce addresses in alphabetical order.
As we know, this can be infinitive, but I saw that they suprimed like 20 colums in one which it would be for names starting with B for examole.
There was a small button that you chicked and it woul spread all of the colums
How do you do it?
RE: 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Recently used file listUnder the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files. |