98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training - Sorting columns alphabetically
excel computer training - Sorting columns alphabetically
Resolved · Low Priority · Version Standard
Thu 14 Dec 2006, 14:12Delegate Emily said...
Emily has attended:
No courses
Sorting columns alphabetically
Hi there,
I am looking to sort my columns alphabetically, but taking into account two different columns. I would like to sort by column A, THEN by column B.
Does that make sense?
Thanks
Emily
Thu 14 Dec 2006, 15:07Trainer Amanda said...
RE: Sorting columns alphabetically
Hi Emily
I would suggest the following:
- Click in a cell in the column you want to sort by first.
- Go to Data - Sort on the menu bar. This allows you to do multiple sorts - the headings at the tops of your columns should be visible in the dropdown sections of the dialogue box on your screen, otherwise Column A, Column B etc will appear.
- Select the first column you wish to sort by, then the second and click OK.
Hope this solves your problem.
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:Adding multiple rows in an Excel 2010 WorksheetIf you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet. |
