This wikiHow teaches you how to alphabetically sort information in Google Sheets and Google Docs.
Step
Method 1 of 2: Sorting Data in Google Spreadsheets
Step 1. Open your workbook in Google Sheets
Go to https://docs.google.com/spreadsheets/ in your browser and click the workbook you want.
- If you are not logged into your Google account, you will be asked to enter your Google account email address and password first.
- If you haven't created a workbook containing the data you want to sort, click Blank, and enter the data you want before continuing.
Step 2. Click the top cell in the column containing the data you want to sort
Then, move the cursor until the last full cell in the same column. The data in the cell will be selected.
Step 3. Click the Data tab near the top of the page
You will see a drop-down menu.
Step 4. Select one of the data sorting options from the following two options:
- Sort sheet by column [column letter], A → Z - This option will sort your data alphabetically, and adjust the rest of the data in the workbook according to the sorting result.
- Sort range by column [column letter], A → Z - This option will only sort your selected column alphabetically.
Method 2 of 2: Sorting Data in Google Docs
Step 1. Open your Google document
docs.google.com/document/ in your browser, then click the workbook you want.
- If you are not logged into your Google account, you will be asked to enter your Google account email address and password first.
- If you haven't created a document containing the data you want to sort, click Blank, and enter the data you want before continuing.
Step 2. Click the Add-ons tab near the top of the page
You will see a drop-down menu.
Step 3. From the menu that appears, click Get add-ons
You will see a window with a list of add-ons.
Step 4. Look for the Sorted Paragraph add-on
Click the search bar in the upper-right corner of the window, then enter sorted paragraphs, and press Enter. The Sorted Paragraphs add-on will appear.
Step 5. Click the blue + FREE button in the right corner of the Sorted Paragraphs bar
Step 6. Select the Google account you are currently using for Google Docs
Step 7. Click ALLOW in the lower right corner of the window to allow Sorted Paragraph to access your Google Docs data
After that, you can access the Sorted Paragraph from the "Add-ons" folder in Google Docs.
Step 8. Select the data you want to sort
Click and drag the cursor until you have finished marking the data you want to sort.
Step 9. Click Add-ons at the top of the page
Step 10. Click Sorted Paragraphs
You'll see a pop-out menu to the right of the Add-ons window.
Step 11. Click Sort A to Z at the top of the menu
The data you select will be sorted alphabetically
