How to alphabetize data in an Excel spreadsheet by column or row, and by using shortcuts
It’s easy to alphabetize data in a Microsoft Excel spreadsheet by row or column using the “Sort” feature.
You can also alphabetize in Excel using shortcuts found in the “Data” or “Home” tabs.
Visit Business Insider’s homepage for more stories.
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 ways to alphabetize rows and columns, the most reliable way is to give instructions within the “Sort” feature, which is found in the “Data” tab.
Additionally, there are shortcuts to quickly reorganize cells from “A to Z” or from “Z to A.” These shortcuts are found in both the “Data” and “Home” tabs.
Excel automatically tries to alphabetize vertically by column, but you can easily adjust this setting to sort horizontally by row.
Here’s how to do it.
Check out the products mentioned in this article:
Microsoft Office 365 Home (From $99.99 at Best Buy)
Macbook Pro (From $1,299 at Best Buy)
Microsoft Surface 2 (From $1,999 at Best Buy)
How to alphabetize columns in Excel
1. Open the Excel spreadsheet you need to alphabetize on your Mac computer or PC.
2. Select the data you want to sort, or do not highlight anything if you wish to sort the entire document.
3. Navigate to the “Data” tab found at the top of the page.
4. Click “Sort” located in the middle of the toolbar.
5. This will open a pop-up with details of how to sort your rows and columns. Excel will automatically populate instructions to sort data by Column A from A to Z.
6. Click the “Column” drop-down menu to change …read more
Source:: Business Insider