Glide Training Logo

Use SORT to keep dropdown lists in A-Z order in Excel and Google Sheets


Today’s quick tip shows you how to use the SORT function to keep your dropdown list items in A-Z sort order in Excel and Sheets. This video assumes prior knowledge of Data Validation for dropdown lists!

If you’d like to see more hints and tips on how to get the best out of the software and apps you use every day, take a look at our YouTube channel. Follow us for regular updates!

Let’s Take It Further

Could you or your team benefit from some face-to-face training?

Glide Training is one of the leading providers of professional IT training in the UK.

We provide training on Microsoft and Google products including Excel, Docs, Word, Sheets, PowerPoint, Slides, Project and more, delivered on-site at your premises or online.

Unlike most training companies we won’t try to sell you a set course from a fixed list; rather we will discuss your specific requirements and work with you to deliver a training programme that gives you what you need to succeed.

find out more

previous post: Use TOROW and TOCOL to combine data into a single row or column in Sheets and Excel

next post: Translate a document quickly and easily in MS Word and Google Docs