A definitive guide to sorting data managed in Microsoft Excel.
This guide takes the mystery and confusion out of Excel’s sorting features. It starts by covering the basics of simple, one-column sorts. It then builds on that information to explain multi-column sorting, setting up and using custom sort orders, sorting based on cell colors or icons, performing case-sensitive sorts, and sorting by rows instead of columns. Step-by-step, fully illustrated instructions make it clear what you need to do. Sample files make it easy to repeat exercises so you can see the same results.
Although this book concentrates on Microsoft Excel 2010 for Windows and Microsoft Excel 2011 for Mac OS, it also provides useful tips and instructions for previous versions of Excel.
I’m really pleased to announce that the second book in the Maria’s Guides series — Sorting Excel Data: The Basics & Beyond — is now out and available in three ebook formats, with a print edition on the way.
About the Book
It all started as a question asked by a friend in Facebook. An experienced computer professional, she didn’t know how to perform a four-column sort in Microsoft Excel. I thought back to my computer applications training days and remembered how my students struggled with Excel’s sorting features. I decided it would make a good topic for a Maria’s Guide book.
While researching and writing the book, I realized just how much Excel’s sorting feature has changed since I wrote my last Excel book several years ago. While it was obviously important for me to cover the most recent Windows and Mac OS versions of Excel, I also wanted to explain complex sorting to folks who haven’t yet upgraded. I think the book does a great job of completely covering how to sort data managed in Excel.
Inside, you’ll find the following chapters:
Table of Contents Before We Begin: Introduction Chapter 1: Sorting Basics Chapter 2: Quick Sorts Chapter 3: Multiple-Column Sorts Chapter 4: Sorting by Color & Icon Chapter 5: Using Custom Sort Orders Chapter 6: Exploring Sort Options Chapter 7: Sorting with Filters & Tables Conclusion: That’s Everything
The printed version of the book runs 114 pages, including front matter, table of contents, and index.
The book uses several example worksheets, all of which are contained in a single workbook file. Readers are encouraged to download the sample file and follow along. This ensures understanding, since readers get the same results that appear in the book.
Buy the Book
The book is currently available as an ebook from three sources (so far):
The print edition is currently going through the proofing process. Once approved, it will be available on Amazon.com and BN.com, as well as by special order through your favorite bookstore.
Additional Material, Feedback, and Support
You can find additional material about Excel on this site. Just follow the Excel topic link.
You can also post questions and read questions and answers on the book’s support page. That’s also where you can find the sample workbook file used throughout the book.
I know it’s been out for a while, but I’ve finally taken the time to download the 997MB video podcast file for the
The application, which is only 3.9 MB in size, is installed in the Applications folder. I double-clicked it, saw a little information screen that told me what it did, and was presented with the Office Converter window. I dragged the Word 2007 file I’d created for Cliff into the window, and waited. About 3 seconds later, I was told that the conversion was successful. (The test file had 18 words in it and two kinds of formatting were applied to some of them.)
The test file was not converted to a Word 2004 format file. That might make too much sense. Instead, it was converted to an RTF file. When I opened it, I found all formatting intact. There was also a blank area for a header and footer, which I didn’t even know RTF supported. Here’s what it looks like in TextEdit.


