[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
When you spend a lot of time working with spreadsheets, you probably have a favorite way of organizing and presenting your data. Fortunately, sorting data in Google Sheets is easy; depending on the data type, you can order it in different ways. If you have cells with text in Google Sheets that you need to alphabetize, you\u2019ve come to the right place.<\/p>\n
In this guide, you will learn about the different methods available to sort your data alphabetically in Google Sheets. First, you will learn how to alphabetize using the built-in column options and then using the menu options: sort sheet, sort range, and advanced range sorting options.<\/p>\n
You will also learn various ways to sort alphabetically without including the first row. Finally, you will learn how to sort your data alphabetically by one or more columns using the SORT function.<\/p>\n
To learn more about sorting data in Google Sheets, check out our guide on how to sort in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-alphabetize-in-google-sheets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To alphabetize your sheets, open the spreadsheet in Google Sheets. Select the column you want to sort by and right-click on the column letter (e.g., \u201cA\u201d). From the menu, choose whether to sort in ascending (A>Z) or descending order (Z>A).<\/p>\n [\/et_pb_text][et_pb_text module_id=”column-options” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Follow the steps below to sort your data using the column menu options.<\/p>\n 1.<\/strong> Open Google Sheets to the file with your data and select the column by which you want to order.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-select-column.webp” alt=”How to alphabetize in Google Sheets \u2014 column A selected in an unsorted list of first and last names” title_text=”Column A selected in an unsorted list of first and last names” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Right-click on the column letter to get the menu and choose ascending or descending alphabetical order.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-right-click-menu.webp” alt=”How to alphabetize in Google Sheets \u2014 right-click column menu with Sort sheet A to Z highlighted” title_text=”Right-click column menu with Sort sheet A to Z highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Alternatively, you can click on the arrow next to the column letter to get the same sort options.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-column-arrow-menu.webp” alt=”How to alphabetize in Google Sheets \u2014 arrow next to column A opening Sort sheet A to Z and Z to A” title_text=”Arrow next to column A opening Sort sheet A to Z and Z to A” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> That\u2019s it. Both columns have been sorted by the first column in ascending alphabetical order.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sorted-by-column-a.webp” alt=”Alphabetize in Google Sheets \u2014 both columns sorted A to Z by column A, starting with Alberta” title_text=”Both columns sorted A to Z by column A, starting with Alberta” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”data-menu-options” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can also sort your data alphabetically from the \u2018Data\u2019 menu. Depending on your selection, you will see the option to sort the sheet or sort a range. Read below to learn the difference between these options.<\/p>\n If you have multiple related columns, this is probably the option you want. It will sort related columns by whatever column you select. In other words, row data is kept together.<\/p>\n 1.<\/strong> Select the column by which you want to sort.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-select-column-b.webp” alt=”Alphabetize in Google Sheets \u2014 column B with last names selected” title_text=”Column B with last names selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to Data > Sort sheet. Select the sort order you want to apply.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-data-sort-sheet.webp” alt=”Alphabetize in Google Sheets \u2014 Data menu with Sort sheet by column B (A to Z)” title_text=”Data menu with Sort sheet by column B (A to Z)” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> That\u2019s it. As you can see below, both columns have been sorted according to the first.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sheet-sorted-column-b.webp” alt=”Alphabetize in Google Sheets \u2014 sheet sorted by last name in column B, starting with Ashley” title_text=”Sheet sorted by last name in column B, starting with Ashley” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can use this option to order only the selected range of cells by the column on the left of your selection. As you will see in the next section, this is useful if you want to avoid sorting the first row. However, you need to be careful with this option. If you only select one column, only that one will be sorted. In other words, your row data will stop making sense.<\/p>\n 1.<\/strong> Select the range of cells you want to sort.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-select-range.webp” alt=”Alphabetize in Google Sheets \u2014 range A13:B23 selected” title_text=”Range A13:B23 selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to Data > Sort range. Select the sort order you want to apply.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-data-sort-range.webp” alt=”Alphabetize in Google Sheets \u2014 Data menu with Sort range by column A (A to Z)” title_text=”Data menu with Sort range by column A (A to Z)” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> That\u2019s it. As you can see below, the selected range has been sorted according to the contents of the first column.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sorted-range.webp” alt=”Alphabetize in Google Sheets \u2014 only rows 13 to 23 sorted by column A, starting with Betty” title_text=”Only rows 13 to 23 sorted by column A, starting with Betty” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To sort data alphabetically by more than one column, go to Data > Sort range > Advanced range sorting options.<\/p>\n 1.<\/strong> Select the range of cells you want to sort, including all relevant rows and columns.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-select-table.webp” alt=”Alphabetical order in Google Sheets \u2014 table A1:G1001 selected with id, first_name and last_name columns” title_text=”Table A1:G1001 selected with id, first_name and last_name columns” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to Data > Sort range > Advanced range sorting options.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-advanced-range-sorting.webp” alt=”Alphabetical order in Google Sheets \u2014 Sort range submenu with Advanced range sorting options” title_text=”Sort range submenu with Advanced range sorting options” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> From the drop-down menu, select the main column by which you want to sort, as well as the sort order. If your table has headers, check the \u201cData has header row\u201d checkbox.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sort-range-dialog.webp” alt=”Alphabetical order in Google Sheets \u2014 Sort range dialog with Data has header row checked and first_name A to Z” title_text=”Sort range dialog with Data has header row checked and first_name A to Z” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Click \u201cAdd another sort column\u201d to add the secondary sort column.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-add-sort-column.webp” alt=”Alphabetical order in Google Sheets \u2014 Add another sort column button in the Sort range dialog” title_text=”Add another sort column button in the Sort range dialog” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> Select the second column to sort by and the sort order. Once you\u2019ve added all the sort columns you need, click \u201cSort\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-second-sort-column.png” alt=”Alphabetical order in Google Sheets \u2014 then by last_name A to Z, with the Sort button highlighted” title_text=”Then by last_name A to Z, with the Sort button highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 6.<\/strong> The table has been sorted alphabetically by more than one column.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sorted-multiple-columns.png” alt=”Alphabetical order in Google Sheets \u2014 table sorted by first name, starting with Abigail, Ada and Addison” title_text=”Table sorted by first name, starting with Abigail, Ada and Addison” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n When you sort the sheet alphabetically, it affects every row. If the first row contains headers, you won\u2019t want it to be sorted. Fortunately, there are several ways to avoid this. You can freeze the top row<\/a> before sorting the sheet or select the cells with data and use \u2018Sort range\u2019. Finally, you can use \u2018Advanced range sorting options\u2019 and check \u201cData has header row\u201d.<\/p>\n Follow the instructions below to freeze the header row before sorting the sheet.<\/p>\n 1.<\/strong> Select the row with the headers.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-select-header-row.png” alt=”Alphabetize in Google Sheets without the first row \u2014 header row 1 selected” title_text=”Header row 1 selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to View > Freeze > 1 row.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-freeze-1-row.png” alt=”Alphabetize in Google Sheets without the first row \u2014 View menu with Freeze and 1 row” title_text=”View menu with Freeze and 1 row” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Now that the first row is frozen, you can select the column by which you want to sort.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-select-sort-column.png” alt=”Alphabetize in Google Sheets without the first row \u2014 first_name column selected under the frozen header” title_text=”First_name column selected under the frozen header” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Go to Data > Sort sheet and select the sort order you want.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sort-sheet-frozen.png” alt=”Alphabetize in Google Sheets without the first row \u2014 Data menu with Sort sheet by column B (A to Z)” title_text=”Data menu with Sort sheet by column B (A to Z)” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> That\u2019s it. The sheet is sorted alphabetically, but the header is unaffected.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sorted-without-header.png” alt=”Alphabetize in Google Sheets without the first row \u2014 sheet sorted by first name with the header row kept on top” title_text=”Sheet sorted by first name with the header row kept on top” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Instead of freezing the top row, you can use the advanced range sorting options to exclude the header.<\/p>\n 1.<\/strong> Select the entire range of cells you want sorted according to one or more columns.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-select-full-range.png” alt=”Alphabetize in Google Sheets without the first row \u2014 range A1:G1001 selected” title_text=”Range A1:G1001 selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to Data > Sort range > Advanced range sorting options.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-advanced-sorting-menu.png” alt=”Alphabetize in Google Sheets without the first row \u2014 Sort range submenu with Advanced range sorting options” title_text=”Sort range submenu with Advanced range sorting options” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Check the \u201cData has header row\u201d checkbox. After that, you can choose one or more columns to sort by, in whatever order you choose for each.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-data-has-header-row.png” alt=”Alphabetize in Google Sheets without the first row \u2014 Data has header row checked in the Sort range dialog” title_text=”Data has header row checked in the Sort range dialog” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-sort-alphabetically-in-google-she” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The methods shown above all change the original data as the sorting is done in place. This means other users, as well as formulas or files that depend on that data, might be affected by your sorting. To avoid this, you can use the built-in SORT function<\/a>.<\/p>\n Follow the steps below to use the SORT function to sort data by one column.<\/p>\n 1.<\/strong> Open the spreadsheet containing your data.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sort-function-cell.png” alt=”Alphabetize in Google Sheets with SORT \u2014 empty cell I1 selected next to the data” title_text=”Empty cell I1 selected next to the data” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Type the SORT function in the cell where you want the sorted data.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-type-sort-function.png” alt=”Alphabetize in Google Sheets with SORT \u2014 =SORT( typed in I1 with the syntax tooltip” title_text=”=SORT( typed in I1 with the syntax tooltip” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Select the range of cells you want to sort and add a comma.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sort-range-argument.png” alt=”Alphabetize in Google Sheets with SORT \u2014 range A2:G1001 entered as the first argument” title_text=”Range A2:G1001 entered as the first argument” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Select the column by which you want to sort and add a comma.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sort-column-argument.png” alt=”Alphabetize in Google Sheets with SORT \u2014 C2:C1001 last_name column entered as the sort column” title_text=”C2:C1001 last_name column entered as the sort column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> For the third parameter, use \u201cTRUE\u201d for ascending alphabetical order and close the parenthesis.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sort-ascending-true.png” alt=”Alphabetize in Google Sheets with SORT \u2014 =SORT(A2:G1001,C2:C1001,TRUE) in the formula bar” title_text=”=SORT(A2:G1001,C2:C1001,TRUE) in the formula bar” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 6.<\/strong> Press \u2018Enter\u2019 to get the sorted data.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sort-function-result.png” alt=”Alphabetize in Google Sheets with SORT \u2014 sorted copy by last name, starting with Aaronsohn, Aartsen and Abel” title_text=”Sorted copy by last name, starting with Aaronsohn, Aartsen and Abel” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n For this example, we will continue from step 5 above. In other words, the data will be sorted by additional columns.<\/p>\n 1.<\/strong> After the third parameter, you can add as many columns as you want by specifying the two parameters necessary for each. I\u2019ll add the \u201cfirst_name\u201d column as the secondary sort column.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sort-second-column.png” alt=”Alphabetize in Google Sheets with SORT \u2014 B2:B1001 first_name column added as the second sort column” title_text=”B2:B1001 first_name column added as the second sort column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> After the comma, add the order you want to use for the secondary sort.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sort-second-order.png” alt=”Alphabetize in Google Sheets with SORT \u2014 TRUE added as the second sort order” title_text=”TRUE added as the second sort order” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Once you\u2019ve added all the columns you want, close the parenthesis and press \u2018Enter\u2019. The data is now sorted by last name, then first name.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/alphabetize-google-sheets-sorted-two-columns.png” alt=”Alphabetize in Google Sheets with SORT \u2014 data sorted by last name, then first name” title_text=”Data sorted by last name, then first name” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”can-you-auto-alphabetize-in-google-sheet” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Depending on the sorting method you choose, your data can be auto-alphabetized. The easiest way to do this is to use the SORT function<\/a>. When new data is added within the selected range, the SORT function will automatically alphabetize the data it returns. See the previous section for instructions.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you have seen, alphabetizing your data in Google Sheets is easy. In fact, there are many ways to do it, depending on your preferences. You know how to sort data in place, changing the original order, as well as how to sort without affecting other users or changing the original order. You know how to alphabetize using the built-in column options and using the menu options: sort sheet, sort range, and advanced range sorting options. You also know a few ways to sort your data alphabetically without including the first row. Finally, you know how to use the SORT function based on one or more sort columns and that this option ensures that it automatically re-alphabetizes when new data is added to the range.<\/p>\n To learn more about sorting and filtering data in Google Sheets, check out these guides on:<\/p>\n To return a sorted list without duplicates, wrap your range in the UNIQUE function<\/a> before you sort it. If you only need some of the rows, the FILTER function<\/a> also leaves the original data untouched, and you can filter Google Sheets without affecting other users<\/a>. When the list you sort comes from other files, Sheetgo<\/a>, an AI-powered data automation platform, can bring that data into one sheet on a schedule, so it stays current and ready for AI.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprenda a colocar em ordem alfab\u00e9tica no Google Sheets: classifique uma coluna ou a p\u00e1gina inteira de A a Z pelo menu Dados, ou use a fun\u00e7\u00e3o SORT para a ordem se atualizar sozinha.<\/p>","protected":false},"author":2,"featured_media":264163,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-264129","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/264129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=264129"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/264129\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/264163"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=264129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=264129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=264129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to alphabetize in Google Sheets?<\/h2>\n
Column options<\/h2>\n
Data menu options<\/h2>\n
Sort sheet by column<\/h3>\n
Sort range by column<\/h3>\n
Sort alphabetically by multiple columns<\/h3>\n
How do I sort alphabetically in Google Sheets without the first row?<\/h3>\n
Freeze top row<\/h3>\n
Advanced range sorting options<\/h3>\n
How to sort alphabetically in Google Sheets with the SORT function?<\/h2>\n
SORT alphabetically by one column<\/h3>\n
SORT alphabetically by multiple columns<\/h3>\n
Can you auto-alphabetize in Google Sheets?<\/h2>\n
Conclusion<\/h2>\n
\n