Separating and organizing/ascending cells by column?

[JPaterson]

Hey,

I've been using Excel a lot recently, but there are some things I nee
to do which I can't figure out.

My first question is, how do I separate cells so that if I insert a ro
into one cell, it DOESN'T insert a row into another column? Fo
example, look at screen one.

http://www.jpatworld.com/excel.jpg

What I want to do is insert a row under "Brian" and above "Carl", but
don't want to insert a row under "Ford" and above "BMW". Is there a wa
I can do this by separating columns A and B so that if I insert a row
it is only inserted into column B? A way to do this by hiding o
freezing panes, maybe?

For my second question, please look at screen two.

http://www.jpatworld.com/excel2.jpg

What I want to do in this one is sort columns A, B, and
alphabetically (ascending), but I want them to remain set up in th
columns the way they are, so that "Vehicle" will take "Spin"'s column
and "Cabinet" would move to cell A3. Is there a way I can do this?
Not that this particular sheet means anything, but I'd like it fo
other projects I'm working on, without having to order everything int
a single column.

Thanks for the help

 

[Biff]

Hi!

For question 1:

Select the cell where you want to insert a new cell.
Goto Insert>Cells
Choose the appropriate option which in your case would be Shift cells down.
OK

For question 2:

For practical purposes, this really can't be done the way you're thinking.
Depending on the actual data you may get "lucky" and be able to repeatedly
sort by column then by row then in ascending then in desending then by
column then by row etc., etc.!! Sort of like one of those games where you
move all the tiles in such a way as to make a picture. But I'm sure this
will take a lot of time! So, your best option is to put everything in a
single column or row then sort.

Biff

 

[Biff]

P.S.

I was able to sort your sample data. Although I didn't count the exact
number of sorts I had to do, it was about 10 to 12.

Biff