Hey,

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

My first question is, how do I separate cells so that if I insert a row into one cell, it DOESN'T insert a row into another column? For 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 I don't want to insert a row under "Ford" and above "BMW". Is there a way 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 or 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 C alphabetically (ascending), but I want them to remain set up in the 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 for other projects I'm working on, without having to order everything into a single column.

Thanks for the help.