{"id":3049,"date":"2013-06-21T19:06:46","date_gmt":"2013-06-21T10:06:46","guid":{"rendered":"http:\/\/fujiitoshiki.com\/improvesociety\/?p=3049"},"modified":"2013-06-21T19:06:46","modified_gmt":"2013-06-21T10:06:46","slug":"how-to-add-direction-into-excel-custom-lists","status":"publish","type":"post","link":"https:\/\/www.fujiitoshiki.com\/improvesociety\/?p=3049","title":{"rendered":"How to add direction into Excel custom lists?"},"content":{"rendered":"

When you’d like to sort with direction, you could not sort because Excel dose not have ‘Direction’ list. So in this article, I’d like to add ‘Direction’ into custom list. First, enter 16 direction from ‘North’ to ‘North-northwest’. <\/p>\n

16 direction from North to North-northwest.<\/figcaption><\/figure>\n
Next, select ‘File’ tab, ‘option’ and ‘Advanced settings’. After scroll down, press ‘Edit custom lists…’ button. <\/p>\n
$\"Edit$ <\/a>
Edit custom list.<\/figcaption><\/figure>\n
Click button on the right column of ‘Range of source list’. <\/p>\n
$\"Press$ <\/a>
Press button to select range.<\/figcaption><\/figure>\n
Drag to select the range you entered ago, press button. Cell range would be entered into the column. Press ‘Import’ button. <\/p>\n
$\"Press$ <\/a>
Press “Import” button.<\/figcaption><\/figure>\n
OK, ‘Direction’ list has been added to custom lists. Press ‘OK’ to close window. <\/p>\n
$\"Custom$ <\/a>
Custom list has been imported.<\/figcaption><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"
When you’d like to sort with direction, you could not sort because Excel dose not have ‘Direction& … “How to add direction into Excel custom lists?” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":3046,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-3049","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts\/3049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3049"}],"version-history":[{"count":6,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts\/3049\/revisions"}],"predecessor-version":[{"id":3056,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts\/3049\/revisions\/3056"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/media\/3046"}],"wp:attachment":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}