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

"Biff" <biffinpitt@comcast.net> wrote in message
news:elBxmT0aGHA.4796@TK2MSFTNGP04.phx.gbl...
> 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
>
> "JPaterson" <JPaterson.2709um_1146280200.5523@excelforum-nospam.com> wrote
> in message news:JPaterson.2709um_1146280200.5523@excelforum-nospam.com...
>>
>> 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.
>>
>>
>> --
>> JPaterson
>> ------------------------------------------------------------------------
>> JPaterson's Profile:
>> http://www.excelforum.com/member.php...o&userid=33967
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=537412
>>
>
>