Can I lock 2 columns together so that the 2 cells in a row are joined?

B

Bernard

Hello,

I want to use Excel to compile a list of my DVDs.

This requires just two columns. The first column will be used to number the
DVD. The second column will be used for the actual name of the DVD.

However, I will want to sort the list in two ways: alphabetically and
numerically.

So the question is: Can I lock these two columns together so that when I
want to see my list alphabetically, the first column that has the number of
the DVD will automatically adjust itself to stay with the DVD.

I hope this makes sense and thank you for your attention and any advice you
can give me.

David
 
D

davesexcel

You could hilight the range you want to sort say
A1:B320 what ever the range is
goto the top menu and select data, sort
the sort menu shows and askes which column to sort by you can eithe
select column A or B

This will sort the way you want it t
 
S

SteveW

When you sort (simple A-Z button) it will select the range of data around
the current cell.

So if you have numbers in A and text in B
then click on a10 and sort will work numerically
and click on b10 and it will sort by name

Only thing is you may want to have a heading for your data
ie A1 "DVD Number"
B1 "DVD Title"

In this case if you sort using the Data, Sort... menu
it willa gain select the whoel region for your data and usuually detect
that the first row is a header.
Choose which column you want to sort on and it will sort, leaving the
header row at the top.


Steve
 
G

Gord Dibben

Just make sure you select both columns prior to doing the sort.

Then sort on whichever column you desire.

Do not rely on Excel to keep the range together, although it does a good job
"most of the time".


Gord Dibben MS Excel MVP
 

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

Top