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, 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!
Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Popular Which Excel course should YOU do- updated to make the report more easy to find Training Dates Training Course Dates– Durban (Kingsmead) and Cape Town- See below Training Course Dates JHB/ PTA Tips and Tricks Copy a cell to … Continue reading
In our courses we often see delegates trying to copy cells to the left and making an incorrect assumption on which part of the cell to click when using the mouse. So in order to copy a cell to the … Continue reading
I can testify that since I have been trained by you online, I really improved my Excel knowledge. But as you know, I am not living in South Africa but I am in Democratic Republic of Congo.– Congo
Please let me know if you have an online version of this session and I will be part of it.