| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
arrange excel by street address instead of alphabetically by name
I'm a realtor with a grand list in excel format. It is currently arranged by
the home owners name in alphabectical order. I would like to arrange by street address in alphabectical order. I have not been using computers for very long so if you reply please tell me in simple terms, step by step. Thanks so much.......Ray |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
arrange excel by street address instead of alphabetically by name
First select the entire list. Say if your list start from A1:Z100, click on
A1 hold down Ctrl + Shift keys, then press the right arrow key until the last cell on the first row highlighted, while holding on those keys, press the down arrow key until the entire list highlighted. Click on Data Sort, on the 'sorty by box select the name of your address column (you have the option to sort by address in ascending [A-Z], or descending order [Z-A]), Click OK, and you are done. Thanks. -- If u change the way u look @ things, the things u look at change. "Ray" wrote: I'm a realtor with a grand list in excel format. It is currently arranged by the home owners name in alphabectical order. I would like to arrange by street address in alphabectical order. I have not been using computers for very long so if you reply please tell me in simple terms, step by step. Thanks so much.......Ray |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
arrange excel by street address instead of alphabetically by n
Hi Sahafi:
Got it highlighted just fine but where do I find "data" "sort" ? Told ya I was kinda new at this so please bear with me. All I have to click on is ....file, edit, view,etc......and there is nothing there that says "data" Thanks so far, I really appreciate it. Ray "sahafi" wrote: First select the entire list. Say if your list start from A1:Z100, click on A1 hold down Ctrl + Shift keys, then press the right arrow key until the last cell on the first row highlighted, while holding on those keys, press the down arrow key until the entire list highlighted. Click on Data Sort, on the 'sorty by box select the name of your address column (you have the option to sort by address in ascending [A-Z], or descending order [Z-A]), Click OK, and you are done. Thanks. -- If u change the way u look @ things, the things u look at change. "Ray" wrote: I'm a realtor with a grand list in excel format. It is currently arranged by the home owners name in alphabectical order. I would like to arrange by street address in alphabectical order. I have not been using computers for very long so if you reply please tell me in simple terms, step by step. Thanks so much.......Ray |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
arrange excel by street address instead of alphabetically by name
Ray
If the street address is in a separate column just select all columns with data and DataSort on street address column. If all data are in one column, you will have to break it out into separate columns possibly using DataText to Columns Wizard. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 14:32:01 -0700, Ray wrote: I'm a realtor with a grand list in excel format. It is currently arranged by the home owners name in alphabectical order. I would like to arrange by street address in alphabectical order. I have not been using computers for very long so if you reply please tell me in simple terms, step by step. Thanks so much.......Ray |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
arrange excel by street address instead of alphabetically by n
Hi:
yes, the name, mailing address, street address.....etc. are all in separate columns. I just don't see anywhere where it says data or sort. It is in microsoft excel viewer if that is helpful. thanks, ray "Gord Dibben" wrote: Ray If the street address is in a separate column just select all columns with data and DataSort on street address column. If all data are in one column, you will have to break it out into separate columns possibly using DataText to Columns Wizard. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 14:32:01 -0700, Ray wrote: I'm a realtor with a grand list in excel format. It is currently arranged by the home owners name in alphabectical order. I would like to arrange by street address in alphabectical order. I have not been using computers for very long so if you reply please tell me in simple terms, step by step. Thanks so much.......Ray |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
arrange excel by street address instead of alphabetically by n
On your menu bar on the top you should see: File | Edit | View | Insert |
Format | Tools | Data | Window | Help. Click on Data, then select sort... etc. If you can see the menu bar above do one of these: I can't find a menu command, toolbar button, or dialog box option. The menu may not be expanded If arrows appear at the bottom of the menu, the command may be available on the expanded menu. Click the arrows, and then click the command you want. You can also double-click the menu to expand it, or you can change the setting to display the entire set of commands for all menus. The toolbar may be on the same row as another toolbar The button may not appear on the toolbar because there isn't enough room to display all buttons. Click More Buttons and then click the button you want, or you can change the setting to show all buttons on the toolbar. The component may not be installed Run the installer again and install the component. You may have a different language setting The command or control doesn't appear if you don't have editing enabled for the language that the command or control applies to. You need to enable editing for the language you want to work with. Learn about multilingual editing and proofing tools kits. -- If u change the way u look @ things, the things u look at change. "Ray" wrote: Hi: yes, the name, mailing address, street address.....etc. are all in separate columns. I just don't see anywhere where it says data or sort. It is in microsoft excel viewer if that is helpful. thanks, ray "Gord Dibben" wrote: Ray If the street address is in a separate column just select all columns with data and DataSort on street address column. If all data are in one column, you will have to break it out into separate columns possibly using DataText to Columns Wizard. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 14:32:01 -0700, Ray wrote: I'm a realtor with a grand list in excel format. It is currently arranged by the home owners name in alphabectical order. I would like to arrange by street address in alphabectical order. I have not been using computers for very long so if you reply please tell me in simple terms, step by step. Thanks so much.......Ray |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
arrange excel by street address instead of alphabetically by n
Ray -
Perhaps the Microsoft Excel Viewer really is just a viewer, therefore maybe it doesn't allow changes, in which case you may need regular Microsoft Excel if you want to sort. And you could probably get a low-priced older version of regular Excel on Ebay or from some other source. - Mike "Ray" wrote in message ... Hi: yes, the name, mailing address, street address.....etc. are all in separate columns. I just don't see anywhere where it says data or sort. It is in microsoft excel viewer if that is helpful. thanks, ray "Gord Dibben" wrote: Ray If the street address is in a separate column just select all columns with data and DataSort on street address column. If all data are in one column, you will have to break it out into separate columns possibly using DataText to Columns Wizard. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 14:32:01 -0700, Ray wrote: I'm a realtor with a grand list in excel format. It is currently arranged by the home owners name in alphabectical order. I would like to arrange by street address in alphabectical order. I have not been using computers for very long so if you reply please tell me in simple terms, step by step. Thanks so much.......Ray |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
arrange excel by street address instead of alphabetically by n
Correct Mike
In viewer the only menu items are File, View, Edit, Window, Help You can autofilter but not save the results but no sorting. Gord On Tue, 12 Jun 2007 19:19:27 -0700, "Mike Middleton" wrote: Ray - Perhaps the Microsoft Excel Viewer really is just a viewer, therefore maybe it doesn't allow changes, in which case you may need regular Microsoft Excel if you want to sort. And you could probably get a low-priced older version of regular Excel on Ebay or from some other source. - Mike "Ray" wrote in message ... Hi: yes, the name, mailing address, street address.....etc. are all in separate columns. I just don't see anywhere where it says data or sort. It is in microsoft excel viewer if that is helpful. thanks, ray "Gord Dibben" wrote: Ray If the street address is in a separate column just select all columns with data and DataSort on street address column. If all data are in one column, you will have to break it out into separate columns possibly using DataText to Columns Wizard. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 14:32:01 -0700, Ray wrote: I'm a realtor with a grand list in excel format. It is currently arranged by the home owners name in alphabectical order. I would like to arrange by street address in alphabectical order. I have not been using computers for very long so if you reply please tell me in simple terms, step by step. Thanks so much.......Ray |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
arrange excel by street address instead of alphabetically by n
Thank you everyone! Just a simple matter of downloading the correct version.
I'm searching for it. Any other suggestions? Thanks again, Ray "Gord Dibben" wrote: Correct Mike In viewer the only menu items are File, View, Edit, Window, Help You can autofilter but not save the results but no sorting. Gord On Tue, 12 Jun 2007 19:19:27 -0700, "Mike Middleton" wrote: Ray - Perhaps the Microsoft Excel Viewer really is just a viewer, therefore maybe it doesn't allow changes, in which case you may need regular Microsoft Excel if you want to sort. And you could probably get a low-priced older version of regular Excel on Ebay or from some other source. - Mike "Ray" wrote in message ... Hi: yes, the name, mailing address, street address.....etc. are all in separate columns. I just don't see anywhere where it says data or sort. It is in microsoft excel viewer if that is helpful. thanks, ray "Gord Dibben" wrote: Ray If the street address is in a separate column just select all columns with data and DataSort on street address column. If all data are in one column, you will have to break it out into separate columns possibly using DataText to Columns Wizard. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 14:32:01 -0700, Ray wrote: I'm a realtor with a grand list in excel format. It is currently arranged by the home owners name in alphabectical order. I would like to arrange by street address in alphabectical order. I have not been using computers for very long so if you reply please tell me in simple terms, step by step. Thanks so much.......Ray |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
arrange excel by street address instead of alphabetically by n
Wasn't paying attention to 'Excel Viewer' comment, and thought Ray is using
full-blown version of MS Excel. Thanks Mike. -- If u change the way u look @ things, the things u look at change. "Mike Middleton" wrote: Ray - Perhaps the Microsoft Excel Viewer really is just a viewer, therefore maybe it doesn't allow changes, in which case you may need regular Microsoft Excel if you want to sort. And you could probably get a low-priced older version of regular Excel on Ebay or from some other source. - Mike "Ray" wrote in message ... Hi: yes, the name, mailing address, street address.....etc. are all in separate columns. I just don't see anywhere where it says data or sort. It is in microsoft excel viewer if that is helpful. thanks, ray "Gord Dibben" wrote: Ray If the street address is in a separate column just select all columns with data and DataSort on street address column. If all data are in one column, you will have to break it out into separate columns possibly using DataText to Columns Wizard. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 14:32:01 -0700, Ray wrote: I'm a realtor with a grand list in excel format. It is currently arranged by the home owners name in alphabectical order. I would like to arrange by street address in alphabectical order. I have not been using computers for very long so if you reply please tell me in simple terms, step by step. Thanks so much.......Ray |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I arrange names alphabetically in Excel? | Excel Discussion (Misc queries) | |||
| How do I arrange worksheets alphabetically in Excel? | Excel Worksheet Functions | |||
| arrange excel worksheets Alphabetically | Excel Worksheet Functions | |||
| arrange columns alphabetically in Excel | New Users to Excel | |||
| How do I arrange entries in a column alphabetically | Excel Discussion (Misc queries) | |||
Linear Mode
