{"id":1801,"date":"2012-10-03T15:54:30","date_gmt":"2012-10-03T15:54:30","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=705"},"modified":"2023-12-30T23:12:17","modified_gmt":"2023-12-30T23:12:17","slug":"excel-training-auto-fill","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-training-auto-fill\/","title":{"rendered":"Excel Training &#8211; Auto Fill"},"content":{"rendered":"<p>Auto fill is a feature of Excel that automates the input of certain data such as days of the week, months of the year and quarters. It\u2019s very simple to do and is a great time saver.<\/p>\n<p>If for example you needed to have days of the week on a spreadsheet, you only have to type in Monday and auto fill will do the rest. Here\u2019s how.<\/p>\n<ol>\n<li>Type Monday (or Mon for short) into a cell and press tab\/return.<\/li>\n<li>Reselect the cell and move the mouse pointer to the bottom right hand corner. It will change from a white cross to a black cross<\/li>\n<li>Hold down the left mouse key whilst the black cross is visible and move it across (or down) the page. As you do you will see the days of the week appear besides the cell it will eventually fill.<\/li>\n<li>Release the mouse button when you have selected the relevant cells.<\/li>\n<\/ol>\n<p>By default all seven days of the week will appear. If you want your spread sheet to list only weekdays, follow these extra steps.<\/p>\n<ol>\n<li>Click on the auto fill options box which will appear beside the last cell in your selected range.<\/li>\n<li>Select \u2018fill weekdays\u2019 from the menu.<\/li>\n<\/ol>\n<p>You can auto fill months of the year and quarters using the first 4 steps.<\/p>\n<p>Why not give it try.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Auto fill is a feature of Excel that automates the input of certain data such as days of the week, months of the year and quarters. It\u2019s very simple to do and is a great time saver. If for example you needed to have days of the week on a spreadsheet, you only have to [&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":[],"class_list":["post-1801","post","type-post","status-publish","format-standard","hentry","category-excel-training"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1801","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=1801"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1801\/revisions"}],"predecessor-version":[{"id":6725,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1801\/revisions\/6725"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}