Select both columns and DataSort on whichever column you want to be key
sort............actors or DVD titles

After sorting, FilePrint AreaSet Print Area.


Gord Dibben MS Excel MVP

On Sun, 24 Aug 2008 19:15:28 +0100, "alan.holmes"
wrote:


How do I sort the data in the columns, I want to make them appear in
alphabetical order?

It is a list of DVDs with some of the actors.

I've just tried to print the list, and I get two separate pages, one with
the titles on and the second with the actors, what I expected was to have a
single page with the information side by side.

How the hell do I do that.

I have done this before, but it must have been a different version of Excel
and I had no trouble then.