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

excel computer training - sorting columns alphabetically

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

excel computer training - Sorting columns alphabetically

ResolvedVersion 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

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.