-=PCTechTalk=- Re: Sorting in Excel

Sorry for the bad news!
:o(
But... at least you learned something new. Would have been worse if you thought 
it sorted fine, when indeed it did not.

Let me know if you need any other help.
 
======================================
= SirTroth
= ICQ: 1717439
= AIM/AOL: SirTrothX
= YAHOO: SirTroth
= MSN: SirTroth@xxxxxxxxxxx (don't email me here)
= SKYPE: SirTroth
= XFIRE: SirTroth
======================================
 

On Mon, 25 Sep 2006 14:59:45 -0400, betty wrote:
> Wow, Troth! I have a lot of work ahead of me. I finally did manage
> to alphabetize the first column, so I now have that no-no situation
> you describe. I'm now going to see if I can UNDO that column so
> that the correct figures are with the original text. I have 2 1/2
> pages in that workbook.
> I played around so much with that first page, I'm sure the figures
> are all fouled up. I think the others should be o.k. once I UNDO.
> It's very, very possible though, that the first page will stay
> fouled up until I start from scratch. UGH!
>
> Thanks so much, Troth
>
> Betty
>
> ~OoO~ wrote:
>> Betty, the table is basically the set of cells that are grouped
>> together to display the information.
>> So... here's an example:
>> http://gisgeek.pdx.edu/swrp/excel_table.jpg
>>
>> Your table, here, is cells A1,A2,A3,B1,B2,B3.
>>
>> Your columns, in this example, is column A and column B... and
>> your rows are 1,2,3.
>>
>> So... using this example... do not highlight the colum...
>>
>> Instead... left-click on A1, and drag to cell B3. You should now
>> have all the cells in the table highlighted (and ONLY the cells
>> in the table). Now, with those cells highlighted (hence, the
>> table highlighted), go ahead and go to DATA > SORT on top.
>>
>> Then follow the rest of the onscreen instructions.
>>
>> On a side note... if you highlight an entire column, and not the
>> rest of the table... IF you are successful sorting, you will ONLY
>> sort that column. The other columns will not sort with that first
>> column. THAT is why it is better to highlight the entire table.
>>
>> For example... if your table is this:
>>
>> A          B          C
>> 2          yes       no
>> 1          no        yes
>> 3          big       small
>>
>> If you highlight column A and successfully sort, the end result
>> is going to be:
>>
>> A          B          C
>> 1          yes       no
>> 2          no        yes
>> 3          big       small
>>
>> Notice that columns B and C remained the same.
>>
>> This is just FYI.
>>
>> ======================================
>> = SirTroth
>> = ICQ: 1717439
>> = AIM/AOL: SirTrothX
>> = YAHOO: SirTroth
>> = MSN: SirTroth@xxxxxxxxxxx (don't email me here) = SKYPE:
>> SirTroth = XFIRE: SirTroth ======================================
>
>
> --
>
>
> To unsub or change your email settings:
> http://www.freelists.org/webpage/pctechtalk
>
> To access our Archives:
> http://groups.yahoo.com/group/PCTechTalk/messages/
> http://www.freelists.org/archives/pctechtalk/


--
<Please delete this line and everything below.>

To unsub or change your email settings:
http://www.freelists.org/webpage/pctechtalk

To access our Archives:
http://groups.yahoo.com/group/PCTechTalk/messages/
http://www.freelists.org/archives/pctechtalk/

Other related posts: