ICON Home Page ICON Members' Forums Home Page
Members' Forums
Username:
Password:
Save Password Forgot your Password?

Home | Profile | Register | Active Topics | Members | Search | FAQ
 
 All ICON Forums
 Help Forums
 Office Applications
 Office Exel List
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

nuggetmike
Supporting Member

97 Posts

Posted - 12/28/2005 :  22:57:05  Show Profile  Visit nuggetmike's Homepage
I made a list 46 cells long by A through J wide. Is there a way to alphabetize the list and keep all columns together? When I try to do this only the A column rearranges. The B-J columns stay the same.

nuggetmike
XP Home, P4,3GHZ, 512 Ram, cable modem,160 GIG Harddrive, 80GIG external BACKUP

D.Oliver
Moderator

868 Posts

Posted - 12/28/2005 :  23:26:18  Show Profile
Glad you asked, Mike.

If you are using Excel 2003, simply click anywhere inside the list box and select DATA>SORT and select the column(s) you want to sort. The entire row moves with the sorted column.

David
old, slow, and confused - but at least I'm inconsistent!
XP-Hm(SP-2) Athlon .5GBRam 160GB Networked 2-Way Satellite
Go to Top of Page

Mick
Administrator

1496 Posts

Posted - 12/28/2005 :  23:27:08  Show Profile  Visit Mick's Homepage
Mike, If you select the entire range of your whole table, before starting the sort, it will probably sort the whole thing. For another thing, for a number of types of operations, Excel likes to have a full set of headers, this means, that at the top of your data, is a set of titles, where the title row is right above the first data row, has no empty cells, and every title is different from all the other titles.

Mick



In technology, procrastination is the way to maximum efficiency -- longer it takes you to jump in, the softer the landing will be, because the "early adopter folks" will have a left pile of bodies to land on.

Go to Top of Page

Mary
Operating Member

368 Posts

Posted - 12/28/2005 :  23:36:29  Show Profile
Select/highlight the complete section 46 rows by J col wide,
click on Data--Sort,
click on the radio button for No header row (unless you have one), under Sort by--click for choice of ascending or descending.
Sort by-- Column A should be in the box by default but you can change it if you wish.

This works in Excel 2003.


WinXP,933MHz
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
ICON Computer Users Group © Interactive Computer Owners' Network Go To Top Of Page
Snitz Forums 2000