Re: Sorting data in excel 2003
- From: "Dave Durber" <d.durber@xxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Wed, 30 Dec 2009 19:02:00 -0500
John:
Thank you for the information.
sincerely:
Dave durber
----- Original Message -----
From: "john.falter" <john.falter@xxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Wednesday, December 30, 2009 6:21 PM
Subject: Re: Sorting data in excel 2003
> From http://www.ehow.com/how_9697_sort-row-column.html
> How to Sort a Row or Column in Excel
>
> Contributor
> By eHow Contributing Writer
> Article Rating:
> account/simple_login
> (33 Ratings)
>
> Excel
> makes it easy to sort a range of values. You might not think of sorting
> spreadsheet values, but it can come in handy; sorting can help alphabetize
a
> column
> of row names, for example. These steps are intended for Microsoft's Excel
> 97.
>
> list of 5 items
> Email
> Print Article
> Add to Favorites
> Flag Article
> Bookmark and Share
> list end
> Difficulty: Moderate
> Instructions
>
> Things You'll Need:
>
> list of 2 items
> . Excel Book
> . Microsoft Excel
> list end
> list of 11 items
> Step 1
> Start
> Microsoft Excel
> and open the file you want to change.
>
> Step 2
> Drag over the two or more columns or rows that you want to sort.
>
> Step 3
> Open the Data menu and select Sort. The Sort dialog box appears.
>
> Step 4
> Select the Continue with the Current Selection option to sort a single
> column or row.
>
> Step 5
> Select the Expand the Selection option to sort a series of columns or
rows.
>
> Step 6
> Choose Ascending or Descending to determine the sort order.
>
> Step 7
> Click the Options button in the Sort dialog box.
>
> Step 8
> Select "Sort top to bottom" in the Sort Options dialog box to sort a
column.
>
> Step 9
> Select "Sort left to right" in the Sort Options dialog box to sort a row.
>
> Step 10
> Click OK in the Sort Options dialog box.
>
> Step 11
> Click OK in the Sort dialog box.
>
> list end
> When I use Quattro Pro 12
> alt plus f9 opens the sort function.
> There probably is a shortcut key for Excel.
>
> ----- 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
Other related posts:
