{"id":425,"date":"2011-10-17T14:07:06","date_gmt":"2011-10-17T14:07:06","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=425"},"modified":"2023-12-30T23:13:14","modified_gmt":"2023-12-30T23:13:14","slug":"excel-tips-using-autofill-for-a-number-sequence","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-tips-using-autofill-for-a-number-sequence\/","title":{"rendered":"Excel Tips: Using Autofill for a Number Sequence"},"content":{"rendered":"<p>Autofill in Excel can be used to complete or extend any number sequence where the gap are equal.<\/p>\n<ul>\n<li>Type in the first two number of the sequence in two adjacent cells<\/li>\n<li>Highlight both entries<br \/>\n<a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/autofill_nums1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-426\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/autofill_nums1.png\" alt=\"\" width=\"121\" height=\"131\" \/><\/a><\/li>\n<li>Drag down from the autofill handle\u00a0<a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/autofill_nums2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-427\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/autofill_nums2.png\" alt=\"\" width=\"60\" height=\"47\" \/><\/a><\/li>\n<li>Drag until you reach the number of entries you require\u00a0<a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/autofill_nums3.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-429\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/autofill_nums3.png\" alt=\"\" width=\"189\" height=\"215\" \/><\/a><\/li>\n<\/ul>\n<p>When you let go you should have the sequence, however if the result wasn\u2019t what you expected use the Auto Fill Options Smart Tag and pick the option you needed.\u00a0<a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/autofill_nums4.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-430\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/autofill_nums4.png\" alt=\"\" width=\"256\" height=\"280\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Autofill in Excel can be used to complete or extend any number sequence where the gap are equal. Type in the first two number of the sequence in two adjacent cells Highlight both entries Drag down from the autofill handle\u00a0 Drag until you reach the number of entries you require\u00a0 When you let go you [&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":[61,171,480,482,495,536],"class_list":["post-425","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-autofill","tag-excel","tag-sequence","tag-sf","tag-smart-tag","tag-tips"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/425","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=425"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/425\/revisions"}],"predecessor-version":[{"id":6765,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/425\/revisions\/6765"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}