Next Live Training Date:

10-14 Nov JHB, 18-20 Nov CT

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 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!

Handy Tips & Tricks

What is PowerPivot

What is PowerPivot PowerPivot is a new ‘free’ tool available in Excel 2010 and Excel 2013 (be careful as it currently does not work in all versions of these two). International experts believe this is a quantum leap in Excel … Continue reading

Powermap Introduction

Powermap Introduction If you make use of Excel 2013 then you should seriously look at getting the free PowerMap add in that allows you to visualise information using a map as the background. As a quick example we used the … Continue reading

...AuditExcel are professional, technically competent and provide solution suited to individual business needs. We are still using the reports and the budget tool they designed and have since been able to enhance the reports ourselves

– Spreadsheet budget app- BDO Auditors

Video Library & Tutorials //

View Entire Video Gallery ››

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Excel Group Rows 2013

Excel Group Rows 2013

Excel text top of cell 2013

Excel text top of cell 2013

Some of our Featured Clients