{"id":1790,"date":"2011-10-17T13:37:24","date_gmt":"2011-10-17T13:37:24","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=411"},"modified":"2023-12-30T23:13:36","modified_gmt":"2023-12-30T23:13:36","slug":"excel-2010-tips-autofill-and-dates","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-2010-tips-autofill-and-dates\/","title":{"rendered":"Excel 2010 Tips Autofill and Dates"},"content":{"rendered":"<p>Autofill is a feature which will copy content down a column or accrss a row.\u00a0 However it also creates sequences, using the same technique, with things that it recognises as being part of a sequence.\u00a0 One such is dates.<\/p>\n<p>Enter the starting date of your sequence in Excel and ensure it is formatted as a date<\/p>\n<p>Select the cell containing your date and drag down from the autofill handle (the autofill handle is the little black square in the bottom right hand corner of the active cell.<\/p>\n<p>A tooltip will appear showing you the date that you have reached as you drag the autofill handle down or across you spreadsheet.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/date_autofill2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-413\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/date_autofill2.png\" alt=\"\" width=\"251\" height=\"145\" \/><\/a><\/p>\n<p>This method works with any date format\u00a0<a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/date_autofill1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-412\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/date_autofill1.png\" alt=\"\" width=\"207\" height=\"120\" \/><\/a><\/p>\n<p>and even with multiple columns<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/date_autofill3.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-414\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/date_autofill3.png\" alt=\"\" width=\"297\" height=\"151\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/date_autofill4.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-415\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/date_autofill4.png\" alt=\"\" width=\"212\" height=\"116\" \/><\/a><\/p>\n<p>As well as full dates and days of the week, autofill will complete a sequence of months and complete a sequence of the three letter names for days of the week or months.\u00a0 Simply enter the day or month you wish to start on and autofill will do the rest.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Autofill is a feature which will copy content down a column or accrss a row.\u00a0 However it also creates sequences, using the same technique, with things that it recognises as being part of a sequence.\u00a0 One such is dates. Enter the starting date of your sequence in Excel and ensure it is formatted as a [&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,148,171,482],"class_list":["post-1790","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-autofill","tag-dates","tag-excel","tag-sf"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1790","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=1790"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1790\/revisions"}],"predecessor-version":[{"id":6767,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1790\/revisions\/6767"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}