excel computer training - sorting columns alphabetically

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training - Sorting columns alphabetically

excel computer training - Sorting columns alphabetically

resolvedResolved · Low Priority · Version Standard

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

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

View all Excel hints and tips


Server loaded in 0.09 secs.