{"id":18729,"date":"2013-05-08T15:55:33","date_gmt":"2013-05-08T10:25:33","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18729"},"modified":"2024-04-12T14:24:18","modified_gmt":"2024-04-12T08:54:18","slug":"sort-lists","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/","title":{"rendered":"Sort Lists"},"content":{"rendered":"<h4><strong>Sort Lists<\/strong><\/h4>\n<p><b>Open the spreadsheet that you wish to sort<\/b>. Because improperly sorting spreadsheets can lead to serious errors with your data (these will be discussed later), it is a good idea to back up your work before following these steps.<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-29037\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1-300x188.jpg\" alt=\"550px-Sort-a-List-in-Microsoft-Excel-Step-1\" width=\"300\" height=\"188\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1-300x188.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1.jpg 550w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><b>Highlight the data to be sorted<\/b>. When doing so, be sure to select all of the the data you need to sort, and none of the data you do not need to sort. While this sounds simple, see below for common errors as well as the correct way to do it. Note: You may not need to highlight your data if the AutoFilter tool has been turned on.<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-29038\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-2-300x187.jpg\" alt=\"550px-Sort-a-List-in-Microsoft-Excel-Step-2\" width=\"300\" height=\"187\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-2-300x187.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-2.jpg 550w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<ul>\n<li>Too little data is selected here. Not everything in the list will be sorted at the same time, leading to mismatches between names and ID numbers (note that Excel will often warn of these errors, but it&#8217;s no substitute for working carefully).\n<div><\/div>\n<\/li>\n<li>Too much data is selected here. In this case the test average from row 18 will be sorted with rest of the information.\n<div><\/div>\n<\/li>\n<li>The proper amount of data has been selected here. This will preserve the integrity of the information and permit sorting by any criteria desired.<\/li>\n<\/ul>\n<p><b>Click on &#8220;Data&#8221; and then &#8220;Sort&#8221; in Excel&#8217;s top menu bar<\/b>. This will then bring up the sort menu.<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-29039\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-3-300x120.jpg\" alt=\"550px-Sort-a-List-in-Microsoft-Excel-Step-3\" width=\"300\" height=\"120\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-3-300x120.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-3.jpg 550w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><b>Choose &#8220;Header row&#8221; or &#8220;No header row&#8221; from the radio buttons on the bottom of the sort menu<\/b>. Choose &#8220;Header row&#8221; if you the top row of your selected data are column names. This is the case in the example images. When you do this, Excel will keep those in place and sort the other information. Otherwise, choose &#8220;No header row&#8221;.<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-29040\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-4-300x137.jpg\" alt=\"550px-Sort-a-List-in-Microsoft-Excel-Step-4\" width=\"300\" height=\"137\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-4-300x137.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-4.jpg 550w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><b>Select your sort criteria and order<\/b>. Excel will sort things alphabetically, numerically or by dates, depending upon what information is in the selected cells. You can also choose to sort in ascending order (from A-Z, least to greatest number, etc.) or in descending order (Z-A, greatest to least number) as suits your needs. You may often find it helpful to sort by multiple criteria. In the example, the list will be sorted by test score (from high to low) and then by last name (from A-Z).<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-5.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-29041\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-5-300x104.jpg\" alt=\"550px-Sort-a-List-in-Microsoft-Excel-Step-5\" width=\"300\" height=\"104\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-5-300x104.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-5.jpg 550w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<div class=\"apply\">\n<h3>Apply for MS Excel Certification Now!!<\/h3>\n<p><a href=\"https:\/\/www.vskills.in\/certification\/excel-online-certification-course\" target=\"_blank\" rel=\"noopener\">https:\/\/www.vskills.in\/certification\/excel-online-certification-course<\/a><\/p>\n<h4><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/certified-excel-2003-professional\/\" target=\"_blank\" rel=\"noopener\"><strong>Back to Tutorial<\/strong><\/a><\/h4>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Sort Lists Open the spreadsheet that you wish to sort. Because improperly sorting spreadsheets can lead to serious errors with your data (these will be discussed later), it is a good idea to back up your work before following these steps. Highlight the data to be sorted. When doing so, be sure to select all&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[47],"tags":[4491],"class_list":["post-18729","page","type-page","status-publish","hentry","category-ms-excel","tag-sort-lists"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sort Lists - Tutorial<\/title>\n<meta name=\"description\" content=\"Sort lists\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sort Lists - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Sort lists\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:54:18+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1-300x188.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/\",\"name\":\"Sort Lists - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1-300x188.jpg\",\"datePublished\":\"2013-05-08T10:25:33+00:00\",\"dateModified\":\"2024-04-12T08:54:18+00:00\",\"description\":\"Sort lists\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/#primaryimage\",\"url\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1-300x188.jpg\",\"contentUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1-300x188.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sort Lists\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sort Lists - Tutorial","description":"Sort lists","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/","og_locale":"en_US","og_type":"article","og_title":"Sort Lists - Tutorial","og_description":"Sort lists","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:54:18+00:00","og_image":[{"url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1-300x188.jpg","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/","name":"Sort Lists - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/#primaryimage"},"thumbnailUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1-300x188.jpg","datePublished":"2013-05-08T10:25:33+00:00","dateModified":"2024-04-12T08:54:18+00:00","description":"Sort lists","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/#primaryimage","url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1-300x188.jpg","contentUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/550px-Sort-a-List-in-Microsoft-Excel-Step-1-300x188.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/sort-lists\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Sort Lists"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=18729"}],"version-history":[{"count":5,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18729\/revisions"}],"predecessor-version":[{"id":130032,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18729\/revisions\/130032"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=18729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=18729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=18729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}