Join Dennis Taylor for an in-depth discussion in this video Sorting columns, part of Managing and Analyzing Data in Excel 2010.
Although not frequently needed, you can sort by rearranging the left or right…order of columns, instead of the much more common rearranging of rows from top to bottom.…As we look at this worksheet here, I think you could begin to see what we're headed for.…We might want to rearrange this data in such a way that our cities are…alphabetized from left to right.…Now, unlike the shortcuts we have seen with prior examples of sorting, we must…highlight all of the data in question here.…What we're about to do as I zoom back here is to select this data specifically.…
This is what we want to rearrange.…We do not want to touch the data in column A at all.…We simply want to rearrange the column data as we see it.…We want Albuquerque to be on the left- hand side, then Atlanta and so on.…We want these alphabetized.…So we must specifically highlight all the data and we must use the Sort…command on the Data tab.…What's different here?…The Options allow us to sort in the unusual sort left to right, not top to bottom.…
Author
Released
10/27/2011- Multiple key sorting
- Single and multiple column numeric filters
- Creating a top-ten list with values or percentages
- Setting up subtotals
- Creating multiple-field criteria filters
- Creating unique lists from repeating field data
- Using the Remove Duplicates command
- Finding duplicate data with specialized arrays
- Counting the number of unique items in a list
- Using SUMIF and COUNTIF functions
- Working with the database functions such as DSUM and DMAX
Skill Level Appropriate for all
Duration
Views
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
Related Courses
-
Setting Up a Database in Excel 2010
with Dennis Taylor43m 23s Appropriate for all -
Excel 2010: Pivot Tables
with Curt Frye3h 43m Intermediate -
Excel 2010: Data Validation
with Dennis Taylor59m 38s Intermediate -
Excel 2010: Charts
with Dennis Taylor3h 38m Intermediate
-
Introduction
-
Welcome50s
-
-
1. Sorting Data
-
Sorting from the Sort menu4m 37s
-
Sorting from the toolbar4m 2s
-
Multi-key sorting3m 4s
-
Sorting columns2m 11s
-
Sorting data in random order2m 42s
-
-
2. Filtering Data
-
Creating custom filters1m 40s
-
3. Creating Automatic Subtotals in Sorted Lists
-
Setting up subtotals4m 20s
-
-
4. Using Advanced Filters
-
5. Eliminating Duplicate Data
-
6. Using Database Analysis Tools
-
Conclusion
-
Next steps34s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Sorting columns