Re: Sorting data in excel 2003
- From: "Dave Durber" <d.durber@xxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Fri, 1 Jan 2010 14:17:07 -0500
Peter and everyone:
Someone else said that the "Sort" option is under the Data Submenu.
As I said in my first posting on this question, I did go through all the
Submenus along the Menu Bar but I could not find the Sort option. The
reason I could not find the Sort Option was that for some weird reason or
other, only known to Microsoft, the Data Menu did not show up on the Menu
Bar. By the way, I did arrow all the way across the Menu Bar until I got
back to the File Submenu.
However, when you all told me where to find it, I pressed the shortcut key
ALT+D, and, hey presto, there was the Data Menu, large as life.
Since I accessed the Data Submenu with ALT+D, guess what, as if by magic,
the Data Submenu now shows as a submenu on the Menu Bar, which it should
have done, all along.
Weird, or what!
Thanks everyone for your help.
Sincerely:
Dave Durber
----- Original Message -----
From: "Peter Holdstock" <peterholdstock@xxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Wednesday, December 30, 2009 6:45 PM
Subject: Re: Sorting data in excel 2003
> Go to the data menu and choose sort.
> Then in the dialogue you will be on a drop down. Choose the first column
> heading you want to sort by, then tab and choose either assending or
> decending.
> Then tab again and choose your next column to sort by, and keep going
until
> you've populated the ones you want. Then hit OK.
>
> Peter
>
> --------------------------------------------------
> From: "Marvin Howdershell" <marvinhowdershell@xxxxxxxxxxx>
> Sent: Wednesday, December 30, 2009 11:19 PM
> To: <jfw@xxxxxxxxxxxxx>
> Subject: Re: Sorting data in excel 2003
>
> > I use Excel version 2003.
> >
> > The sort option is under the data submenu.
> >
> > I have not done any sorts since I retired. I am rusty but I have some
of
> > my old worksheets.
> > If you have questions, please post. I will reply.
> >
> > Marvin
> >
> > ----- Original Message -----
> > From: "Dave Durber" <d.durber@xxxxxxxxx>
> > To: <jfw@xxxxxxxxxxxxx>
> > Sent: Wednesday, December 30, 2009 5:15 PM
> > Subject: Sorting data in excel 2003
> >
> >
> >> Hello Listers:
> >>
> >> You guys are my last resort.
> >>
> >> I need to sort a spreadsheet in excel 2003 in different ways, for
various
> >> purposes.
> >>
> >> The fields are: FirstName; LastName; Primary Phone Number; Email
> >> Address;
> >> Address1; Address2; City; State; Zip; Date Joined.
> >>
> >> For various reasons, I need to sort the spreadsheet by LastName, City,
> >> State, Zip, Date Joined.
> >>
> >> I have searched the menus thoroughly, without finding the sort
function.
> >>
> >> I tried using Excel's "Help" function, and not getting any result.
> >>
> >> I will be very grateful if someone can point me in the right direction.
> >>
> >> Thanks in anticipation.
> >>
> >> sincerely:
> >>
> >> Dave Durber
> >>
> >> --
> >> JFW related links:
> >> JFW homepage: http://www.freedomscientific.com/
> >> Scripting mailing list:
> >> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> >> JFW List instructions:
> >> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> >> To unsubscribe from this mailing list, send a message to
> >> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject
line.
> >> Archives located at: //www.freelists.org/archives/jfw
> >> Alternative archives located at:
> >> http://n2.nabble.com/JAWS-for-Windows-f2145279.html
> >>
> >> If you have any concerns about the list, post received from the list,
or
> >> the way the list is being run, do not post them to the list. Rather
> >> contact the list owner at jfw-admins@xxxxxxxxxxxxxx
> >>
> >
> >
> > --
> > JFW related links:
> > JFW homepage: http://www.freedomscientific.com/
> > Scripting mailing list:
> > http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> > JFW List instructions:
> > To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> > To unsubscribe from this mailing list, send a message to
> > jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> > Archives located at: //www.freelists.org/archives/jfw
> > Alternative archives located at:
> > http://n2.nabble.com/JAWS-for-Windows-f2145279.html
> >
> > If you have any concerns about the list, post received from the list, or
> > the way the list is being run, do not post them to the list. Rather
> > contact the list owner at jfw-admins@xxxxxxxxxxxxxx
> >
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> Archives located at: //www.freelists.org/archives/jfw
> Alternative archives located at:
http://n2.nabble.com/JAWS-for-Windows-f2145279.html
>
> If you have any concerns about the list, post received from the list, or
the way the list is being run, do not post them to the list. Rather contact
the list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
Alternative archives located at:
http://n2.nabble.com/JAWS-for-Windows-f2145279.html
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
