An Excel worksheet containing an area prepared for the SORTBY function's result. The result of a SORTBY formula in Excel, with the data sorted by the Points column.

Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more.

Please note: This item is from our archives and was published in 2001. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I know I can sort ...

You can sort all the rows in a worksheet. Chron Logo Hearst Newspapers Logo. Skip to main content. Newsletters. ... its sorting function permanently rearranges your data unless you undo the results.

Launch Excel and open the spreadsheet that contains the list that you want to sort. Click to select a range of data, such as A1 through A20, or click the header to select the entire column of data.

One of the most common functions in an Excel spreadsheet is sorting data alphabetically.. This feature is extremely helpful for organizing lists of names, cities, and more. While there are several ...

Microsoft 365's UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula.

How to sort in Google Sheets on a computer. One everyday use for a spreadsheet is keeping track of your contacts, so for this example, we’ll demonstrate how to alphabetize a contact list.