![]() One way to do this is to select the upper-leftmost cell you want to sort and then drag your cursor to the lower-rightmost cell in the sort range ( Figure E). First, make sure to freeze any header rows with the View | Freeze command, as described above.Ģ. ![]() This is useful when you want to sort first by one column, then another, such as when sorting by last name and then first name, for example.ġ. In a web browser, Google Sheets also offers the option to sort by multiple columns. How to alphabetize by more than one column You may need to tap this triangle more than once to navigate to the desired setting, such as Freeze Row (middle) or, when a column is selected, Sort A-Z or Sort Z-A (right). Tap the right-pointing triangle to access additional menu options. On iOS, tap the right triangle More menu as many times as needed until the option to tap either Sort A-Z or Sort Z-A is available, then tap your desired sort order ( Figure D).įigure D In the Google Sheets app on iOS, tap twice on row or column identifiers (e.g., 1,2,3, etc. On Android, tap the three-vertical dot More menu, then tap Sort A-Z or Sort Z-A ( Figure D). The first tap selects the column, the second tap brings up a menu. Mobile app: Along the top side of your sheet, tap the column letter (e.g., A, B, C, etc.) slowly twice. To change the sort type or column, repeat this step.įigure C In a Google Sheet on the web, select a cell in a column, then choose Data | Sort Sheet By… options to sort either A-Z or Z-A. For example, to alphabetize Column C, you would click on any cell in Column C, then choose Data | Sort Sheet By Column C, A → Z. You may freeze header columns or rows (middle image) and sort columns (right image).īrowser: Select a cell in the column you wish to sort, then select Data followed by the type of sort, either A → Z or Z → A ( Figure C). or A,B,C, etc.) to bring up the More menu (left image). On iOS, tap the right triangle More Menu, then tap Freeze Row ( Figure B).įigure B In the Google Sheets app on Android, tap twice on row or column identifiers (e.g., 1,2,3, etc. On Android, tap the three-dot More menu, then tap Freeze ( Figure B). ![]() The first tap selects the row, the second tap brings up a menu. Mobile app: Along the left side of your sheet, tap the row number (e.g., 1, 2, 3, etc.) twice. For a single line header, which is common, you would select View | Freeze | 1 row.įigure A If your sheet has header rows, make sure to Freeze the header rows (View | Freeze | select as appropriate) before a sort. Choose View | Freeze, then select the number of rows you need to freeze. The process works similarly in Google Sheets in a web browser as it does in the Google Sheets mobile apps.īrowser: If your Sheet has a header row, you’ll need to freeze the header row(s)–otherwise, the system will sort your header data along with everything else ( Figure A). You can sort cells in a Google Sheet in either alphabetical or reverse-alphabetical order. SEE: Cloud Data Storage Policy (TechRepublic Premium) How to alphabetize a column The Google Sheets mobile apps also offer single-column sort capabilities.įollow the instructions below to sort your sheet A-Z or Z-A on the web, Android or iOS. ![]() The latter option helps you organize items when data may be the same in multiple cells, such as when sorting by a country, a state and then a city. The first reorganizes your data alphabetically with a single-column sort, while the second lets you sort first by one column, then another, then another and so on. Research: The complexities of multicloud deployments are often worth the benefits, even in uncertain times Learn how to adapt your business to the cloud for just $30 Cloud: Must-read coverageĬomparing Microsoft Azure and Google Cloud Google Sheets on the web offers at least two distinct alphabetical sort options. An alphabetical sort can not only bring a bit of order to these lists, but also help us recognize patterns, such as inaccurate or duplicated data. Google Sheets often helps people manage lists of people, things and places. For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Sort A-Z or Z-A in Google Sheets on any platform and also sort in sequence by more than one column on the web.
0 Comments
Leave a Reply. |