Sorting Data - Revision history

Grojoh24: /* Extra Help */

2011-10-26T03:12:36Z

‎Extra Help

2011-10-26T02:43:54Z

‎Extra Help

2011-10-26T02:42:35Z

2011-10-21T23:22:01Z

‎Sorting Multiple Columns

2011-10-21T23:21:47Z

‎Sorting By Row

2011-10-21T23:21:20Z

‎Sorting By Row

2011-10-21T23:21:04Z

2011-10-21T23:20:37Z

2011-10-21T23:20:15Z

2011-10-21T23:19:57Z

← Older revision		Revision as of 03:12, 26 October 2011
Line 41:		Line 41:
	You should be back in the Sort Dialogue Box now, with some different options. In the Sort By drop down, you should be able to select rows (Row 1, Row 2, etc.) instead of other designators. Make sure you select the correct row.		You should be back in the Sort Dialogue Box now, with some different options. In the Sort By drop down, you should be able to select rows (Row 1, Row 2, etc.) instead of other designators. Make sure you select the correct row.

−	~~==Extra Help==~~

−	~~[[http://www.contextures.com/xlSort01.html/ This website]] is a more detailed tool for help with sorting data.~~
−
	[[category:Excel]]		[[category:Excel]]

@@ Line 43: / Line 43: @@
 ==Extra Help==
-This [[http://www.contextures.com/xlSort01.html/ This website]] is a more detailed tool for help with sorting data.
+[[http://www.contextures.com/xlSort01.html/ This website]] is a more detailed tool for help with sorting data.
   [[category:Excel]]

← Older revision		Revision as of 02:42, 26 October 2011
Line 41:		Line 41:
	You should be back in the Sort Dialogue Box now, with some different options. In the Sort By drop down, you should be able to select rows (Row 1, Row 2, etc.) instead of other designators. Make sure you select the correct row.		You should be back in the Sort Dialogue Box now, with some different options. In the Sort By drop down, you should be able to select rows (Row 1, Row 2, etc.) instead of other designators. Make sure you select the correct row.

		+	==Extra Help==
		+
		+	This [[http://www.contextures.com/xlSort01.html/ This website]] is a more detailed tool for help with sorting data.
	[[category:Excel]]		[[category:Excel]]

@@ Line 17: / Line 17: @@
 Next you'll need to change the Sort By option to suit what you want your data to be sorted by first.  You can also choose what to sort the data on (Values, Cell Color, Font Color or Cell Icon) and whether to go from A to Z (for text), Largest to Smallest (for numbers), or vice verse.  Once you have this figured, you can start to Add Levels to your sorting options, for example:
-<br>
 [[File:Excelsort03.png|250px]]
@@ Line 24: / Line 25: @@
 [[File:excelsort04.png|250px]]
 ==Sorting By Row==

@@ Line 29: / Line 29: @@
 This is a simple procedure, with one or two very important minor details.  First, get back into the Sort Dialogue Box, and go to the Options button.
 [[File:excelsort05.png|250px]]
 Then, simply select 'Sort left to right'.  This will enable sorting by column.  Now press OK.  Only one more step.
 [[File:excelsort06.png|250px]]
-You should be back in the Sort Dialogue Box now, with some different options.  In the Sort By drop down, you should be able to select rows (Row 1, Row 2, etc.) instead of other designators.  Make sure you select the correct row.  If you don't, your data won't be sorted correctly!
+You should be back in the Sort Dialogue Box now, with some different options.  In the Sort By drop down, you should be able to select rows (Row 1, Row 2, etc.) instead of other designators.  Make sure you select the correct row.
   [[category:Excel]]

← Older revision		Revision as of 23:21, 21 October 2011
Line 23:		Line 23:
	Now that all your filters are set, your data will be sorted as you see below:		Now that all your filters are set, your data will be sorted as you see below:

−	[[File:excelsort04.png]]	+	[[File:excelsort04.png\|250px]]

@@ Line 2: / Line 2: @@
 ==Quick Sort==
 The easiest, and quickest, way to sort data in Excel is to use the Quick Sort button in the Data tab.
 [[File:Excelsort01.png]]
@@ Line 18: / Line 19: @@
 <br>
 [[File:Excelsort03.png|250px]]
-<br>
 Now that all your filters are set, your data will be sorted as you see below:
 [[File:excelsort04.png]]
 ==Sorting By Row==

@@ Line 9: / Line 9: @@
 There are two ways to sort multiple columns: using a prescribed sorting method (preloaded conditions) or using a custom sorting method (conditions you enter yourself). Go to the Data tab and select the Sort macro key (shown below).  This will Bring up the Dialogue Box.
-<br>
 [[File:Excelsort02.png|250px]]
-<br>
 Next you'll need to change the Sort By option to suit what you want your data to be sorted by first.  You can also choose what to sort the data on (Values, Cell Color, Font Color or Cell Icon) and whether to go from A to Z (for text), Largest to Smallest (for numbers), or vice verse.  Once you have this figured, you can start to Add Levels to your sorting options, for example:
 <br>