{"id":1788,"date":"2011-10-10T20:36:28","date_gmt":"2011-10-10T20:36:28","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=388"},"modified":"2023-12-30T23:13:37","modified_gmt":"2023-12-30T23:13:37","slug":"excel-2010-creating-custom-lists","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-2010-creating-custom-lists\/","title":{"rendered":"Excel 2010: Creating Custom Lists"},"content":{"rendered":"<p>There are many built in lists in Excel, numerical, date\/time, text and numerical, and some text entries for month and day (try typing Jan in a cell and replicate the sequence down with the bottom right corner of the cell). For sequences that are not immediately available, Excel gives you the option of creating your own customised text lists.<\/p>\n<p>Go to the <strong>File<\/strong> tab and select <strong>Options<\/strong>. On the <strong>Advanced<\/strong> page (tab at the left), scroll down to the <strong>General<\/strong> section where you see the <strong>Edit Custom Lists<\/strong> button. Click to open the dialog box.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/CustomLists.jpg\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-389\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/CustomLists.jpg\" alt=\"Adding a custom list\" width=\"490\" height=\"380\" \/><\/a>If you have a list already in a spreadsheet, select the cells first. Now go to the Custom Lists dialog box and use the Import button to save retyping the entries.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are many built in lists in Excel, numerical, date\/time, text and numerical, and some text entries for month and day (try typing Jan in a cell and replicate the sequence down with the bottom right corner of the cell). For sequences that are not immediately available, Excel gives you the option of creating your [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[134,173,376,489],"class_list":["post-1788","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-custom-lists","tag-excel-2010","tag-mjw","tag-shortcuts"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1788","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1788"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1788\/revisions"}],"predecessor-version":[{"id":6771,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1788\/revisions\/6771"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}