Separating and organizing/ascending cells by column?

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.

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
>

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
>>
>
>