How to Sort Data Alphabetically in Google Docs: 15 Steps

How to Sort Data Alphabetically in Google Docs: 15 Steps
How to Sort Data Alphabetically in Google Docs: 15 Steps

Table of contents:

Anonim

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

Alphabetize in Google Docs Step 1
Alphabetize in Google Docs Step 1

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.
Alphabetize in Google Docs Step 2
Alphabetize in Google Docs Step 2

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.

Alphabetize in Google Docs Step 3
Alphabetize in Google Docs Step 3

Step 3. Click the Data tab near the top of the page

You will see a drop-down menu.

Alphabetize in Google Docs Step 4
Alphabetize in Google Docs Step 4

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

Alphabetize in Google Docs Step 5
Alphabetize in Google Docs Step 5

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.
Alphabetize in Google Docs Step 6
Alphabetize in Google Docs Step 6

Step 2. Click the Add-ons tab near the top of the page

You will see a drop-down menu.

Alphabetize in Google Docs Step 7
Alphabetize in Google Docs Step 7

Step 3. From the menu that appears, click Get add-ons

You will see a window with a list of add-ons.

Alphabetize in Google Docs Step 8
Alphabetize in Google Docs Step 8

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.

Alphabetize in Google Docs Step 9
Alphabetize in Google Docs Step 9

Step 5. Click the blue + FREE button in the right corner of the Sorted Paragraphs bar

Alphabetize in Google Docs Step 10
Alphabetize in Google Docs Step 10

Step 6. Select the Google account you are currently using for Google Docs

Alphabetize in Google Docs Step 11
Alphabetize in Google Docs Step 11

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.

Alphabetize in Google Docs Step 12
Alphabetize in Google Docs Step 12

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.

Alphabetize in Google Docs Step 13
Alphabetize in Google Docs Step 13

Step 9. Click Add-ons at the top of the page

Alphabetize in Google Docs Step 14
Alphabetize in Google Docs Step 14

Step 10. Click Sorted Paragraphs

You'll see a pop-out menu to the right of the Add-ons window.

Alphabetize in Google Docs Step 15
Alphabetize in Google Docs Step 15

Step 11. Click Sort A to Z at the top of the menu

The data you select will be sorted alphabetically

Tips

If you want to reverse the order of data in Google Docs or Google Sheets, click the button Z → A or A → Z.

Recommended:

How to Archive Alphabetically (with Pictures)

How to Archive Alphabetically (with Pictures)

Archiving alphabetically is a way of organizing documents that are important in both personal and professional life. Alphabetical archiving allows you to quickly find and restore individual files. This ensures all documents are protected and always at hand.

How to Sort a List in Microsoft Excel: 15 Steps

How to Sort a List in Microsoft Excel: 15 Steps

Excel is great for tables and data, but how can you use and structure it so that it meets your needs? The Sort tool lets you quickly sort columns with various formats, or you can create your own formats for multiple columns and data types. Use the Sort function to organize your data and make it easier to understand and use.

How to Arrange Alphabetically in Microsoft Word: 8 Steps

How to Arrange Alphabetically in Microsoft Word: 8 Steps

Listing alphabetically is a great skill to learn in Word, especially if you deal with directories and lists a lot. Fortunately, the sorting process is fairly easy once you learn how to access it. Follow this guide to learn how for any version of Word.

How to Arrange Alphabetically: 10 Steps (with Pictures)

How to Arrange Alphabetically: 10 Steps (with Pictures)

Alphabetical sorting is a useful and effective way to arrange words, information, and objects for school, work, or personal use. Whether you're planning to sort your important documents or your large collection of records alphabetically, the alphabetical order rules can be more complicated than just understanding your ABCs.

How to Sort Laundry: 10 Steps (with Pictures)

How to Sort Laundry: 10 Steps (with Pictures)

Laundry is one of the necessities of life. Clean clothes allow you to feel comfortable, maintain a clean appearance and maintain the quality of your clothes. However, many people don't realize that there is a safer and more effective way to wash clothes than simply throwing them in the washing machine.