-=PCTechTalk=- Re: Sorting in Excel

That;s exactly right, Troth. I certainly did think I solved the
problem, never dreaming that the figures stayed the same.
Of course now that I understand, from you excellent example,
it seems so simple, and it is certainly logical.
Thanks for your great wisdom, and most especially, your instant
answer and sharing and caring.

Betty

~OoO~ wrote:
> 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 ======================================
>>>       
>> --
>>
>>     
>   


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