If you need to sort a list based on data in a specific column, you don't need to use the Sort dialog box. With the active cell in the specific column (do not select the entire column), press the single AZ (ascending) or ZA (descending) button to sort the list, re-arranging the rows based on the data in that column.
- [Voiceover] There are a lot of different way to sort data…in Excel, and the standard way is to go to the Data tab in…the ribbon, and use either of the single AZ or ZA…sort buttons or the larger button that leads us into…the Sort dialogue box.…Sorting can be a lot faster, sometimes just with…keystroke shortcuts or a simple click…on the AZ or ZA button.…Now before sorting data, you should always have a sense…or know that your data is in one solid cluster.…No empty rows within the data, no empty columns.…
If you have converted your data to a table,…you don't worry about that very much,…so I'd highly recommend exploring that option…if you haven't already.…This list has no empty rows or columns within it…and I might wanna sort it quickly, simply by employee name.…I can click anywhere in column A, click the AZ button,…there it is, simple, fast.…At a later time, maybe I wanna sort by building.…I'll click there, click AZ.…Now, what's important to remember…is that when you use these button singly,…Excel remembers what you had done before,…
Author
Dennis Taylor
Released
4/21/2016The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "10 Tiny Tips" chapter for a quick productivity boost.
- Entering today's date or time instantly
- Converting formulas to values with a simple drag
- Undoing and redoing with keyboard commands
- Accessing the Ribbon from the keyboard
- Creating split screens fast
- Navigating in workbooks quickly
- Selecting noncontiguous ranges
- Entering data more efficiently
- Dragging and dropping data
- Performing calculations without formulas
- Applying formatting with keyboard shortcuts
- Using database techniques to work with Excel data
- Working with charts, shapes, and linked images
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome33s
-
-
1. Top 10 Shortcuts
-
Zoom in and out quickly3m 23s
-
2. Ribbon and Quick Access Toolbar Tips
-
3. Display Shortcuts
-
4. Navigation Shortcuts
-
Navigate within worksheets7m 10s
-
5. Selection Shortcuts
-
6. Data Entry and Editing Shortcuts
-
Accelerate data entry9m 54s
-
Enhance editing tools3m 40s
-
-
7. Drag and Drop Techniques
-
8. Formula Shortcuts
-
Create formulas rapidly6m 26s
-
Use AutoSum shortcuts3m 53s
-
Use rounding shortcuts5m 30s
-
Generate random numbers5m 3s
-
-
9. Operational Shortcuts
-
Re-align imported text5m 44s
-
10. Formatting Shortcuts
-
11. Data Management Techniques
-
12. Charting and Visual Object Tips
-
13. Ten Tiny Tips
-
Conclusion
-
Goodbye33s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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: Sort data with single buttons