{"id":3658,"date":"2015-01-27T18:50:46","date_gmt":"2015-01-27T17:50:46","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=3658"},"modified":"2020-09-04T09:40:48","modified_gmt":"2020-09-04T07:40:48","slug":"tvorba-sdileni-vlastnich-seznamu","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/tvorba-sdileni-vlastnich-seznamu\/","title":{"rendered":"Create and share custom lists"},"content":{"rendered":"<p><\/p>\n<p style=\"text-align: justify;\">Users commonly use predefined series of numbers, dates, days of the week or month. Besides these, you can create your own custom list\u00a0(eg. the foreign\u00a0names of the days, months, list of\u00a0counties and cities, etc..), which will accelerate the formation of stereotypes, frequently used, consecutive values.<\/p>\n<h2 style=\"text-align: justify;\">Custom lists<\/h2>\n<p>Creating custom lists\u00a0is a litlle\u00a0hidden setting in Excel, according to version differs the procedure.<\/p>\n<ul>\n<li>2003: Tools\u00a0&gt; Options\u00a0&gt;\u00a0Custom lists<\/li>\n<li>2007: Office\u00a0button\u00a0&gt; Excel options &gt;\u00a0Edit custom lists<\/li>\n<li>2010 and newer: File\u00a0&gt; Options\u00a0&gt; Advanced\u00a0&gt; Edit custom lists<a href=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2015\/01\/01.jpg\"><br \/>\n<\/a><\/li>\n<\/ul>\n<figure id=\"attachment_3660\" aria-describedby=\"caption-attachment-3660\" style=\"width: 640px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2015\/01\/01.jpg\"><img decoding=\"async\" class=\"size-full wp-image-3660\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2015\/01\/01.jpg\" alt=\"Soubor - Mo\u017enosti\" width=\"640\" height=\"466\" title=\"\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2015\/01\/01.jpg 640w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2015\/01\/01-300x218.jpg 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><figcaption id=\"caption-attachment-3660\" class=\"wp-caption-text\">File &#8211; Options (czech)<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">In the Custom Lists window, select the new list and in the right pane write the list of values in a row separated by commas, or below. If multiple values are entered in a range\u00a0of cells on a worksheet, you can select them\u00a0by <strong>Import list from cells<\/strong> and confirm the option Import.<\/p>\n<p style=\"text-align: justify;\">Such series are stored in the user profile settings and will\u00a0work in all Excel files.<\/p>\n<figure id=\"attachment_3661\" aria-describedby=\"caption-attachment-3661\" style=\"width: 675px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2015\/01\/02.jpg\"><img decoding=\"async\" class=\"size-full wp-image-3661\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2015\/01\/02.jpg\" alt=\"Vlastn\u00ed seznamy\" width=\"675\" height=\"387\" title=\"\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2015\/01\/02.jpg 675w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2015\/01\/02-300x172.jpg 300w\" sizes=\"(max-width: 675px) 100vw, 675px\" \/><\/a><figcaption id=\"caption-attachment-3661\" class=\"wp-caption-text\">Custom lists<\/figcaption><\/figure>\n<h2>The possibility of sharing\u00a0settings<\/h2>\n<p style=\"text-align: justify;\">If you want to back up the lists\u00a0for later use, or want to share with others, there are some options. The actual series\u00a0are not stored in a file, which could be easily copied. The following procedure is for advanced users only.<\/p>\n<h3>Searching the\u00a0registry<\/h3>\n<p>Setting up custom lists are stored in the registry:<\/p>\n<ol>\n<li>Run\u00a0<strong>regedit<\/strong><\/li>\n<li><em>Search for key\u00a0HKEY_CURRENT_USER\\Software\\Microsoft\\Office\\15.0\\Excel\\Options<\/em>\n<ul>\n<li>number of version after \\Office\\ is derived from the version of MS Office, Office 2013 is 15.0<\/li>\n<\/ul>\n<\/li>\n<li><strong>SmartList<\/strong>\u00a0 key contains information about custom lists<\/li>\n<li>Options can be exported, create a .reg file and then import the key on another computer<\/li>\n<\/ol>\n<h3>Saving using macros<\/h3>\n<p style=\"text-align: justify;\">Using this code you can\u00a0create a macro, that after running the file, adds the values entered in column A, starting with cell A1 (in the sheet\u00a0called &#8220;value_list&#8221;) to\u00a0set up custom lists. The sample file with the macro can be downloade\u00a0<a title=\"Makro vlastn\u00ed seznamy\" href=\"https:\/\/www.itlektor.cz\/soubory\/vlastni_seznam_makro.zip\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/p>\n<pre lang=\"vb\" line=\"1\">Sub Auto_Open()\r\n    On Error Resume Next\r\n    Application.AddCustomList _\r\n        ListArray:=Sheets(\"value_list\").Range(\"A1\", Range(\"A1\").End(xlDown))\r\nEnd Sub\r\n<\/pre>\n<p style=\"text-align: justify;\">If this guide has helped you, become a fan on <a href=\"http:\/\/www.facebook.com\/itlektorcz\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n<p><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Users commonly use predefined series of numbers, dates, days of the week or month. Besides these, you can create your own custom list\u00a0(eg. the foreign\u00a0names of the days, months, list of\u00a0counties and cities, etc..), which will accelerate the formation of stereotypes, frequently used, consecutive values. Custom lists Creating custom lists\u00a0is a litlle\u00a0hidden setting in Excel, [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":3661,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3],"tags":[10,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/3658"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=3658"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/3658\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/3661"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=3658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=3658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=3658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}