{"id":109741,"date":"2018-10-11T20:35:51","date_gmt":"2018-10-11T20:35:51","guid":{"rendered":"http:\/\/sftarticles.wpenginepowered.com\/en\/?p=109741"},"modified":"2025-07-01T22:54:16","modified_gmt":"2025-07-02T05:54:16","slug":"how-to-sort-data-in-google-sheets","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/en\/how-to-sort-data-in-google-sheets\/","title":{"rendered":"How to sort data in Google Sheets"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-111153\" src=\"https:\/\/articles-img.sftcdn.net\/sft\/articles\/auto-mapping-folder\/sites\/3\/2018\/10\/google-sheets-700.jpg\" alt=\"Google Sheets\" width=\"700\" height=\"394\" srcset=\"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2018\/10\/google-sheets-700.jpg 700w, https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2018\/10\/google-sheets-700-300x169.jpg 300w, https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2018\/10\/google-sheets-700-664x374.jpg 664w, https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2018\/10\/google-sheets-700-238x134.jpg 238w, https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2018\/10\/google-sheets-700-436x246.jpg 436w, https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2018\/10\/google-sheets-700-370x208.jpg 370w, https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2018\/10\/google-sheets-700-304x170.jpg 304w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p>Google Sheets is a relatively\u00a0easy program when you start out. However, figuring out some of the more advanced features can be tricky. Below, we&#8217;ll explain how to sort your\u00a0data in Google Sheets in just four easy steps.<\/p>\n<h2>How to sort data in Google Sheets<\/h2>\n<h3>1. Open Google Sheets<\/h3>\n<p>If you want to sort your data, you&#8217;ll first need to open Google Sheets. You can access the program through your Google Drive. If you&#8217;ve never used Google Sheets before, keep in mind it is comparable to Excel (or any other spreadsheet program you may have used). After you have opened Google Sheets, simply select the sheet that has the data that you need to organize.<\/p>\n<div class=\"sc-card-program\">\r\n  <div class=\"sc-card-program__body\">\r\n    <div class=\"sc-card-program__row clearfix\">\r\n      <div class=\"sc-card-program__col-logo\">\r\n        <img decoding=\"async\" class=\"sc-card-program__img\" alt=\"Google Drive\" src=\"https:\/\/images.sftcdn.net\/images\/t_optimized,f_auto\/p\/a4ff16fe-96d1-11e6-a92a-00163ec9f5fa\/1950955591\/google-drive-logo.png\" width=\"100px\" height=\"100px\">\r\n      <\/div>\r\n      <div class=\"sc-card-program__col-title\">\r\n        <span class=\"sc-card-program__title\">Google Drive<\/span>\r\n        <a class=\"sc-card-program__button sc-card-program-internal\" href=\"https:\/\/google-drive.en.softonic.com\/\" target=\"_self\" rel=\"noopener noreferrer\">Download Google Drive<\/a>\r\n      <\/div>\r\n      <div class=\"sc-card-program__col-rating\">\r\n        <svg class=\"rating-score__content\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.1\" x=\"0\" y=\"0\" viewbox=\"0 0 50 50\" enable-background=\"new 0 0 50 50\" xml:space=\"preserve\"><path class=\"rating-score__background rating-score--good\" fill=\"none\" stroke-width=\"6\" stroke-miterlimit=\"10\" d=\"M40 40c8.3-8.3 8.3-21.7 0-30s-21.7-8.3-30 0 -8.3 21.7 0 30\"><\/path><path class=\"rating-score__value rating-score__value--70\" fill=\"none\" stroke-width=\"6\" stroke-dashoffset=\"70\" stroke-miterlimit=\"10\" d=\"M40 40c8.3-8.3 8.3-21.7 0-30s-21.7-8.3-30 0 -8.3 21.7 0 30\"><\/path><text class=\"rating-score__number\" content=\"7\" text-anchor=\"middle\" transform=\"matrix(1 0 0 1 25 31.0837)\" data-auto=\"app-user-score\">7<\/text><\/svg>\r\n      <\/div>\r\n    <\/div>\r\n    <div class=\"sc-card-program__row\">\r\n      <span class=\"sc-card-program__description\"><\/span>\r\n    <\/div>\r\n    <div class=\"sc-card-program__row\">\r\n      <img decoding=\"async\" class=\"sc-card-program__bigpic\" src=\"\" onerror=\"this.style.display='none'\">\r\n    <\/div>\r\n    <a class=\"sc-card-program__link track-link sc-card-program-internal\" href=\"https:\/\/google-drive.en.softonic.com\/\" target=\"_self\" rel=\"noopener noreferrer\"><\/a>\r\n  <\/div>\r\n<\/div>\n<h3>2. Choose your column<\/h3>\n<p>The first step to sorting your data is to choose the column of data that you want to organize. Select the column by clicking on the letter at the top of it, right above Row 1. All the columns are organized by letters&#8230; so if you&#8217;re confused, just look for the row at the top of the screen that lists the letters in alphabetical\u00a0order.<\/p>\n<h3>3. Open the menu<\/h3>\n<p>Hover the cursor over the letter of the column you&#8217;ve selected. A small arrow should appear to the right of the letter, on the far right side of the column. Click on this arrow to open a dropdown menu.<\/p>\n<h3>4. Sort your data alphabetically<\/h3>\n<p>Finally, if you want to sort the data alphabetically, click the SORT A\u2013Z button or\u00a0SORT Z\u2013A button. After you have selected how you want to sort your data, the program will automatically put it in order in the spreadsheet.<\/p>\n<p>Now that you know how to sort your data in Google Sheets, you can get started. Remember to wield this newfound power for good.<\/p>\n<!-- Shortcode [playwire] does not match the conditions -->\n<div class=\"sc-related-articles-white\">\r\n<p class=\"sc-related-articles-white__title\">More from Softonic<\/p>\r\n  <div class=\"sc-related-articles-white__row\">\r\n    <a title=\"The best ways to collaborate in Google Docs \u25ba\" href=\"https:\/\/en.softonic.com\/articles\/the-best-ways-to-collaborate-in-google-docs\/\">\r\n    <div class=\"sc-related-articles-white__article\">\r\n      <div class=\"sc-related-articles-white__image\">\r\n        <div style=\"background-image:url(https:\/\/articles-img.sftcdn.net\/sft\/articles\/auto-mapping-folder\/sites\/3\/2018\/07\/Screen-Shot-2018-07-13-at-6.35.21-PM.png)\"><\/div>\r\n      <\/div>\r\n      <div class=\"sc-related-articles-white__text\">\r\n        <p>The best ways to collaborate in Google Docs \u25ba<\/p>\r\n      <\/div>\r\n    <\/div>\r\n    <\/a>\r\n    <a title=\"How to create an easy budget in Google Sheets \u25ba\" href=\"https:\/\/en.softonic.com\/articles\/how-to-create-an-easy-budget-in-google-spreadsheets\/\">\r\n    <div class=\"sc-related-articles-white__article\">\r\n      <div class=\"sc-related-articles-white__image\">\r\n        <div style=\"background-image:url(https:\/\/articles-img.sftcdn.net\/sft\/articles\/auto-mapping-folder\/sites\/3\/2018\/07\/sheets.jpg)\"><\/div>\r\n      <\/div>\r\n      <div class=\"sc-related-articles-white__text\">\r\n        <p>How to create an easy budget in Google Sheets \u25ba<\/p>\r\n      <\/div>\r\n    <\/div>\r\n    <\/a>\r\n  <\/div>\r\n  <div class=\"sc-related-articles-white__row\">\r\n    <a title=\"Tips and tricks for writing a novel in Google Docs \u25ba\" href=\"https:\/\/en.softonic.com\/articles\/tips-and-tricks-for-writing-a-novel-in-google-drive\">\r\n    <div class=\"sc-related-articles-white__article\">\r\n      <div class=\"sc-related-articles-white__image\">\r\n        <div style=\"background-image:url(https:\/\/articles-img.sftcdn.net\/sft\/articles\/auto-mapping-folder\/sites\/3\/2018\/06\/Screen-Shot-2018-06-28-at-12.03.52-PM.png)\"><\/div>\r\n      <\/div>\r\n      <div class=\"sc-related-articles-white__text\">\r\n        <p>Tips and tricks for writing a novel in Google Docs \u25ba<\/p>\r\n      <\/div>\r\n    <\/div>\r\n    <\/a>\r\n    <a title=\"Things you didn\u2019t know you could do with Google Drive \u25ba\" href=\"https:\/\/en.softonic.com\/articles\/things-you-didnt-know-you-could-do-with-google-drive\/\">\r\n    <div class=\"sc-related-articles-white__article\">\r\n      <div class=\"sc-related-articles-white__image\">\r\n        <div style=\"background-image:url(https:\/\/articles-img.sftcdn.net\/sft\/articles\/auto-mapping-folder\/sites\/3\/2018\/06\/GOOGLE-DOCS.jpg)\"><\/div>\r\n      <\/div>\r\n      <div class=\"sc-related-articles-white__text\">\r\n        <p>Things you didn\u2019t know you could do with Google Drive \u25ba<\/p>\r\n      <\/div>\r\n    <\/div>\r\n    <\/a>\r\n  <\/div>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Sorting data in Google sheets is easy. Follow us.<\/p>\n","protected":false},"author":9167,"featured_media":109745,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","wpcf-pageviews":0},"categories":[2441],"tags":[2340,1068,1046],"usertag":[],"vertical":[],"content-category":[],"class_list":["post-109741","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to","tag-app-subdomain-redirectiongoogle","tag-google","tag-google-drive"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/109741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/users\/9167"}],"replies":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/comments?post=109741"}],"version-history":[{"count":1,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/109741\/revisions"}],"predecessor-version":[{"id":327222,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/109741\/revisions\/327222"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media\/109745"}],"wp:attachment":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media?parent=109741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/categories?post=109741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/tags?post=109741"},{"taxonomy":"usertag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/usertag?post=109741"},{"taxonomy":"vertical","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/vertical?post=109741"},{"taxonomy":"content-category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/content-category?post=109741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}