arrange excel by street address instead of alphabetically by name

[Ray]

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

 

[sahafi]

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.

 

[Ray]

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

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.

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

 

[Gord Dibben]

Ray

If the street address is in a separate column just select all columns with data
and Data>Sort on street address column.

If all data are in one column, you will have to break it out into separate
columns possibly using Data>Text to Columns Wizard.


Gord Dibben MS Excel MVP

 

[Ray]

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

 

[sahafi]

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.

 

[Mike Middleton]

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

 

[Gord Dibben]

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

 

[Ray]

Thank you everyone! Just a simple matter of downloading the correct version.
I'm searching for it. Any other suggestions?
Thanks again,
Ray

 

[sahafi]

Wasn't paying attention to 'Excel Viewer' comment, and thought Ray is using
full-blown version of MS Excel. Thanks Mike.