J
jbclem
I'm using a Excel 2002 spreadsheet to keep notes and Column A has the category phrase, Columns B, C, etc... have text
associated with the category. The problem is that the Col A category phrase is usually one word (ie Computer, Internet,
Politics) on one row, and the particular text associated with that phrase often occupies more than one row. Since I
have many categories, and repetitions of them, I want to be able to sort Col A alphabetically and have the text in the
related Columns (B,C, etc...) be locked to the category in Col A so that the text will also go along with the sort. Is
this possible in Excel?
Here's an example of what I mean:
A B C
==========================================================
Politics blah blah blah blah blah
more blah blah blah blah
blah blah blah
Internet blah blah blah blah
blahblah blahblah blah blah
Computer yes yes yes yes yes yes maybe,yes yes yes yes
nonononononoblahblah why not, maybe, if, but
blahblah, blahblah blah
Internet okokokokokokokok yesterday,today,manana, aujourdhui
okdokyokdokywhatever
Computer dell,yahoo,google,mahimahi,tarzan,jane,silver,alaska,moose,winkwink
hoje,ontem,amanha,sabado,domingo,hier,byebye,ciao,chow,woff,meow
Internet day-o,da-a-a-a-a-a-a-ay-ay-ay o
daylight come n me wanna go home
==========================================
It's a very useful way to jot down notes and things I want to remember, and be able to access easily. But I need to be
able to alphabetize the categories to make it easier to find things because the spreadsheet is getting too long.
Any ideas about this...?
John
associated with the category. The problem is that the Col A category phrase is usually one word (ie Computer, Internet,
Politics) on one row, and the particular text associated with that phrase often occupies more than one row. Since I
have many categories, and repetitions of them, I want to be able to sort Col A alphabetically and have the text in the
related Columns (B,C, etc...) be locked to the category in Col A so that the text will also go along with the sort. Is
this possible in Excel?
Here's an example of what I mean:
A B C
==========================================================
Politics blah blah blah blah blah
more blah blah blah blah
blah blah blah
Internet blah blah blah blah
blahblah blahblah blah blah
Computer yes yes yes yes yes yes maybe,yes yes yes yes
nonononononoblahblah why not, maybe, if, but
blahblah, blahblah blah
Internet okokokokokokokok yesterday,today,manana, aujourdhui
okdokyokdokywhatever
Computer dell,yahoo,google,mahimahi,tarzan,jane,silver,alaska,moose,winkwink
hoje,ontem,amanha,sabado,domingo,hier,byebye,ciao,chow,woff,meow
Internet day-o,da-a-a-a-a-a-a-ay-ay-ay o
daylight come n me wanna go home
==========================================
It's a very useful way to jot down notes and things I want to remember, and be able to access easily. But I need to be
able to alphabetize the categories to make it easier to find things because the spreadsheet is getting too long.
Any ideas about this...?
John