O'Reilly logo

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 23. Sorting in Excel

  • How can I sort sales transaction data so that transactions are sorted first by salesperson, then by product, then by units sold, and finally in chronological order from oldest to most recent?

  • I have always wanted to sort my data based on cell color or font color. Is this possible in Excel 2007?

  • I love the great icons described in Chapter 22. Can I sort my data based on the icon in the cell?

  • My worksheet includes a column containing the month in which each sale occurred. When I sort by this column, I get either April (first month alphabetically) or October (last month alphabetically) on top. How can I sort by this column so that January transactions are on top, followed by February, and so on?

  • Can I sort data without using ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required