Popular spreadsheet program Google Sheets can do a whole lot of cool stuff, but not every function and every option is easy to find. This sadly includes common and very necessary functions – such as sorting data according to the alphabet.
Thankfully, it’s actually quite easy to do so! Simply follow the instructions below.
First, click on the field above the row of data you want to sort by – in other words, if, in a user database, you want to sort by last name, click on the field above the column that has all the last names in it. Said column will be highlighted.
Right-click anywhere within the highlighted area and a large menu will pop up – look for the option to “Sort Sheet A -> Z” or “Sort Sheet Z -> A”, depending on which way around you want it to be.
Be aware that doing this won’t just change up the column you’ve selected, but will move the entire rows. In other words, it won’t just order the last names and leave everything in place but re-order all the records, so don’t worry about accidentally mixing things up too much!
Tip: You can do this to any column you’d like – it also works on fields that contain numbers. While it will still say A->Z, it will order them numerically, 1->9.
Did this help? Let us know!