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

How to set up Excel to print wrapped columns on a page. 1
getting cells to shift to next column 3
How to group similar column titles together???? 2
How to keep Column headers with Autofilter & Freeze Panes 8
wrap text from one column to the next 1
Add a number '1' next to highest number in column 3
Countif - How do I count the number of job titles occurring in a l 3
counting identical items in a column and returning the occurrences 3

Top