Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2007

Tip: Looking for answers? Try searching our database.

arrange excel by street address instead of alphabetically by name

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ray - 12 Jun 2007 22:32 GMT
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 - 12 Jun 2007 23:07 GMT
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.
Signature

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
Ray - 12 Jun 2007 23:51 GMT
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
[quoted text clipped - 11 lines]
> > very long so if you reply please tell me in simple terms, step by step.
> > Thanks so much.......Ray
Gord Dibben - 13 Jun 2007 00:36 GMT
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

>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
Ray - 13 Jun 2007 00:58 GMT
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

> Ray
>
[quoted text clipped - 11 lines]
> >very long so if you reply please tell me in simple terms, step by step.
> >Thanks so much.......Ray
sahafi - 13 Jun 2007 02:01 GMT
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.

Signature

If u change the way u look @ things, the things u look at change.

> Hi:
> yes, the name, mailing address, street address.....etc. are all in separate
[quoted text clipped - 19 lines]
> > >very long so if you reply please tell me in simple terms, step by step.
> > >Thanks so much.......Ray
Mike Middleton - 13 Jun 2007 03:19 GMT
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

> Hi:
> yes, the name, mailing address, street address.....etc. are all in
[quoted text clipped - 24 lines]
>> >very long so if you reply please tell me in simple terms, step by step.
>> >Thanks so much.......Ray
Gord Dibben - 13 Jun 2007 03:45 GMT
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  -
>
[quoted text clipped - 33 lines]
>>> >very long so if you reply please tell me in simple terms, step by step.
>>> >Thanks so much.......Ray
Ray - 13 Jun 2007 15:30 GMT
Thank you everyone! Just a simple matter of downloading the correct version.
I'm searching for it. Any other suggestions?
Thanks again,
Ray

> Correct Mike
>
[quoted text clipped - 41 lines]
> >>> >very long so if you reply please tell me in simple terms, step by step.
> >>> >Thanks so much.......Ray
sahafi - 13 Jun 2007 15:33 GMT
Wasn't paying attention to 'Excel Viewer' comment, and thought Ray is using
full-blown version of MS Excel. Thanks Mike.
Signature

If u change the way u look @ things, the things u look at change.

> Ray  -
>
[quoted text clipped - 33 lines]
> >> >very long so if you reply please tell me in simple terms, step by step.
> >> >Thanks so much.......Ray
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.