-=PCTechTalk=- Re: Sorting in Excel

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: