对电子表格中的数据进行排序不仅可以方便地查找所需内容，而且也是组织数据的好方法。我们将向您展示如何在Google 表格(Google Sheets)中按字母顺序排列，以便您可以保持数据整洁。
您可以在Google 表格(Google Sheets)网站或移动应用程序中按字母顺序对数据进行排序，尽管该网站为您提供了更大的灵活性。如果您准备好了解它，让我们按字母顺序排列这些数据。
(Sort Alphabetically)在网络(Web)上的Google 表格(Google Sheets)中按字母顺序排序
如果您在网络上使用 Google 表格，则可以按字母顺序排列整个工作表或一系列单元格（例如列）。访问Google 表格(Google Sheets)，登录您的Google帐户，然后打开工作簿即可开始。
按字母顺序排列工作表
要按字母顺序排列工作表，您将使用特定的列作为排序依据。工作表中的其余列将更新，以便您的数据保持完整。
选择要作为排序依据的列并执行以下操作之一：
- 选择列标题右侧的箭头或右键单击该列并在下拉菜单中选择按A – Z 排序。(Sort A – Z)要按相反的字母顺序排序，请选择“排序 Z(Sort Z) – A”
。
- 转到“数据”(Data)选项卡，移至“排序(Sort)工作表”，然后选择“按列排序工作表”（A 到 Z）。(Sort)要反向排序，请选择按列排序(Sort)工作表（Z 到 A）。
注意：如果您有标题行，它们将包含在字母顺序中。
按字母顺序排列单元格范围
要按字母顺序排列特定单元格范围而不是整个工作表，这也是一种选择。请(Just)记住，您的其他列不会更新以与排序的数据保持同步。
转到“数据”(Data)选项卡，移至“排序(Sort)范围”，然后选择按列排序(Sort)范围（A 到 Z）。要按降序排序，请选择按列排序(Sort)范围（Z 到 A）。
然后您会看到您的范围按字母顺序排序。
按字母顺序排列多个单元格范围
如果您有一个工作表，您想要按列按字母顺序排序，同时还要对其他数据列进行排序，则可以执行高级排序。
- 选择要按字母顺序排列的数据。这应包括所有单元格范围或列。
- 转到“数据”(Data)选项卡，移至“排序(Sort)表”，然后选择“高级(Advanced)范围排序选项”。
- 在弹出窗口中，选中顶部的“数据(Data)有标题行”框，以便根据需要从排序中排除此数据。
- 下面，您将看到排序依据的第一列。确保(Make)标记 A 到 Z 选项（或 Z 到 A 以反向排序）。
- 选择添加另一个排序列。
- 在出现的下拉框中选择要排序的第二列，并标记旁边的 A 到 Z 选项（或 Z 到 A 进行反向排序）。
- 对单元格区域中要作为排序依据的所有列继续此过程。
- 完成后，选择排序。
然后，您将看到数据(see your data sorted)按每列的字母顺序排序。
(Sort Alphabetically)在移动设备(Mobile)上的Google 表格(Google Sheets)中按字母顺序排序
只需轻按几下，您就可以在移动设备上的Google 表格(Google Sheets)应用中按字母顺序排列电子表格。尽管该功能较为有限，但您仍然可以按字母顺序对数据进行排序。
- 在Android或 iPhone 上打开Google 表格(Google Sheets)应用，找到要排序的工作表。
- 然后，您将选择一个作为排序依据的列。然后按该特定列对整个工作表进行排序。
- 点击列顶部的字母标题将其选中，然后再次点击它以打开小操作工具栏。
- 使用工具栏右侧的箭头在操作中移动，直到看到“ A – Z 排序”(Sort A – Z)选项并选择它。
然后，您将看到工作表更新为按该列的字母顺序排序。附加列的更新就像在网站上一样。
当您想要对Google电子表格中的数据进行从 A 到 Z 的排序时，这很容易做到。现在您已经了解了如何在Google 表格(Google Sheets)中按字母顺序排列，请参阅我们在 Microsoft Excel 中按字母顺序排列(alphabetizing in Microsoft Excel)的教程。
How to Alphabetize in Google Sheets (Mobile and Computer)
Sorting data in your sрreаdsheet can be a convenient way to find what you need but also a good way to organize it. We’ll show you how to alphabetize in Google Sheets so you can keep your data nice and neat.
You can sort your data alphabetically on the Google Sheets website or in the mobile app, although the website gives you a bit more flexibility. If you’re ready to get to it, let’s alphabetize that data.
Sort Alphabetically in Google Sheets on the Web
If you use Google Sheets on the web, you can alphabetize your whole worksheet or a range of cells, like a column. Visit Google Sheets, sign into your Google account, and open a workbook to get started.
Alphabetize a Sheet
To alphabetize a sheet, you’ll use a specific column to sort by. The remaining columns in your sheet will update so that your data remains intact.
Choose the column that you want to sort by and do one of the following:
- Select the arrow to the right of the column header or right-click the column and pick Sort A – Z in the drop-down menu. To sort in reverse alphabetical order, pick Sort Z – A.
- Go to the Data tab, move to Sort sheet, and pick Sort sheet by column (A to Z). To sort in reverse, pick Sort sheet by column (Z to A).
Note: If you have a header row, these will be included in the alphabetization.
Alphabetize a Cell Range
To alphabetize a particular cell range instead of the whole sheet, this is also an option. Just keep in mind that your other columns will not update to stay in sync with the sorted data.
Go to the Data tab, move to Sort range, and pick Sort range by column (A to Z). To sort in descending order, pick Sort range by column (Z to A).
You’ll then see your range sorted alphabetically.
Alphabetize Multiple Cell Ranges
If you have a sheet where you want to sort by a column alphabetically but also sort additional columns of data, you can perform an advanced sort.
- Select the data you want to alphabetize. This should include all cell ranges or columns.
- Go to the Data tab, move to Sort sheet, and pick Advanced range sorting options.
- In the pop-up window, check the box at the top for Data has header row to exclude this data from the sort if you like.
- Below, you’ll see the first column to sort by. Make sure to mark the A to Z option (or Z to A to sort in reverse).
- Select Add another sort column.
- Choose the second column to sort by in the drop-down box that appears and mark the A to Z option next to it as well (or Z to A to sort in reverse).
- Continue this process for all columns you want to sort by in the cell range.
- When you finish, select Sort.
You’ll then see your data sorted alphabetically by each column, in order.
Sort Alphabetically in Google Sheets on Mobile
You can alphabetize your spreadsheet in the Google Sheets app on your mobile device in just a few taps. Although the feature is more limited, you can still sort your data alphabetically.
- Open the Google Sheets app on Android or iPhone to the sheet you want to sort.
- You’ll then choose a column to sort by. This then sorts the entire sheet by that specific column.
- Tap the letter header at the top of the column to select it and then tap it again to open the small toolbar of actions.
- Use the arrow on the right side of the toolbar to move through the actions until you see the Sort A – Z option and select it.
You’ll then see your sheet update to sort alphabetically by that column. The additional columns update just like on the website.
When you want to sort data in your Google spreadsheet from A to Z, it’s easy to do. Now that you know how to alphabetize in Google Sheets, look at our tutorial for alphabetizing in Microsoft Excel too.
