Next Live Training Date:

JHB 15-19 Aug , DBN 19-21 Sep CT 12-14 Oct

Excel Automatic Sort

Excel automatic sort is an important tool… with Excel you’re going to have to sort out data many times, be it a few entries or hundreds of entries.

Let’s look at what you should do, remembering that for any help, there is always us at AuditExcel, so you certainly don’t need to feel frustrated or feel like giving up. Automatic sort in Excel is very handy and saves you time.

Numeric values:

Numeric values, including things like date and time are sorted from lowest to highest.
Excel automatic sort doesn’t consider the format of the cell, only its contents. Date and time are sorted by their numeric values.

Text:

Text is sorted first by ASCII characters, such as *, (,),  and then by letters of the alphabet. Uppercase text is sorted before lowercase text. To sort using case sensitivity: from the Data menu, select Sort, then Options, and then select the Case Sensitive option.

By downloading Excel Training, you can watch video clips within the example spreadsheet and you can try Excel automatic sort as you watch… there is training material to be purchased, and there are consultants with expert advice.  With Audit Excel you can’t go wrong; trust in us… we’ll sort you out!

Free Tips & Tricks Newsletter

Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!

Handy Tips & Tricks

All the countries that use MMDDYYYY

The date format of MMDDYYYY is a potential problem for many people the world round. The main reason for this is that most people don’t understand how Excel handles dates. But first the background. Who uses MMDDYYYY Per Wikipedia  the … Continue reading

The Magic of Spreadsheets Podcast

The recent Marks & Spencer spreadsheet blunder will inevitably lead to more questions about the use of spreadsheets. In this podcast from the Financial Times, Lisa Pollack reports on the latest attempts to make spreadsheets more formal and professional. Listen to the … Continue reading

Your (AuditExcel) Advance Excel and Financial Modeling course is one of the best courses available on the market, it is well structured, relevant and insightful. I will recommend it to anyone who would like to improve his/her Excel and/or Financial Modeling skills.

– Namibia

Video Library & Tutorials //

View Entire Video Gallery ››

Making the same change to multiple worksheets in Excel

Making the same change to multiple worksheets in Excel

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Some of our Featured Clients