Re: Sorting data in excel 2003
- From: "john.falter" <john.falter@xxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Wed, 30 Dec 2009 18:21:59 -0500
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
Other related posts:
