How to Alphebetize one column, but keep next column together with

E

EvasiveFox

Hi all, I have a list of movie titles in one column and the CD number on
which the movie is found, in the next column. How do I sort the movie titles
by alphabetical name in column one, while keeping the disk number in the next
column together with the title, so that I know what disk it's on? I've been
trying to figure this one out for days now - please help :)

For example....

TITLES DISK #
Days of Thunder 1
Armegeddon 2
Jurassic Park 3

I would like it to look like

TITLES DISK #
Armegeddon 2
Days of Thunder 1
Jurassic Park 3

If anyone can figure this out, I'd really appreciate it - thanks!
 
P

Per Jessen

Hi

Select both columns, goto Data > Sort > Sort by: Column A (Titles)

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Style to 'Keep with previous' instead of Keep with Next 1
Space at end of multi page list to accommodate new entries 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
How to set up Excel to print wrapped columns on a page. 1
Adding a big matrix in Word 2013 5
List all tables, including document structure 0
Remove Identical words 0
Document Merge Formatting Issue 0

Top