Hi

Is there any way of locking all cells next to each other accross so that the
document can only be ssorted via columns?

I want to use Excel as a DVD database whereby all the information of a
particualr DVD is stored as fields accross the documnet i.e. title, genre,
year, number.

If I wanted to sort my database for example by genre, I could hightlight
that field's column and then click on the chronological sort icons.
Unfortunately, if the cells accross aren't locked then this would be useless
as a DVD's fields would no longer relate to each other.

I know it is possible to lock 2 fields (columns) together and then sort them
by whichever was highlighted first.

Thanks for your attention and any advice you can give me.

David