{"id":1002,"date":"2012-11-06T14:10:07","date_gmt":"2012-11-06T14:10:07","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1002"},"modified":"2023-12-30T23:12:47","modified_gmt":"2023-12-30T23:12:47","slug":"get-more-out-of-autofill-in-excel-what-can-it-do","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/get-more-out-of-autofill-in-excel-what-can-it-do\/","title":{"rendered":"Get more out of Autofill in Excel – What can it do?"},"content":{"rendered":"

Autofill is rapidly becoming a new trick for me today. \u00a0I’ve used it to add weekdays, months of the year, and numbering columns. \u00a0But there is more to it than that and Excel offers a range of Autofill options.<\/p>\n

To get the full list of options, you need to find the Auto Fill Options\u00a0button. \u00a0In Excel 2010 this is located in the Home tab, in the Editing section.<\/p>\n

Tip: If you use Autofill a lot, add it to your quick access toolbar for extra speedy autofilling!<\/p><\/blockquote>\n

\"Autofill<\/a>
Autofill is hidden in the editing section in the Home tab.<\/figcaption><\/figure>\n

Autofill will give you a list of options depending on the \u00a0type of data you are using. \u00a0In Excel this will include anything from text, to numbers and formulas. It does more than just series in text or numbers.<\/p>\n

 <\/p>\n

 <\/p>\n

\"autofill-shortcut-excel-online-courses\"<\/a><\/p>\n

When you are using autofill, the\u00a0fill handle\u00a0<\/strong>appears as a black square at the bottom right of the active cell.
\nAutofill options can also appear as a shortcut menu<\/strong>. \u00a0To view it, you need to click on the right mouse button, and drag the\u00a0fill handle<\/strong>\u00a0to an adjacent cells. Excel will give you a list of options to use.<\/p>\n

What can Autofill do?\u00a0<\/strong>With Autofill, you can do the following:<\/p>\n

    \n
  1. Copy Cells\u00a0<\/strong>– a quick way to copy the content from one cell into more cells . For example a member of staff’s name or department.\n

    \"Autofill-copy-text-excel-online-courses\"<\/a>
    Autofill will copy text to save you typing it manually<\/figcaption><\/figure><\/li>\n
  2. Fill Series\u00a0<\/strong>– This can even include a combination of text and a number. \u00a0I could type Staff Member 1, and then use the Fill handle to complete the series automatically. \u00a0This is also useful for common series such as business quarters, and Excel will recognise the sequence even if you use standard abbreviations such as Qtr 1, Qtr 2, Qtr 3, Qtr 4.\n

    \"Autofill-text-and-number-excel-online-courses\"<\/a>
    Autofill text and number sequence<\/figcaption><\/figure><\/li>\n
  3. Fill Formatting Only\u00a0<\/strong>– a simple example could be filling a series of cells with a colour.\n

    \"Autofill-format-excel-online-course\"<\/a>
    Autofill a format to save time<\/figcaption><\/figure><\/li>\n
  4. Fill Without Formatting –\u00a0<\/strong>for when you want to autofill without the formatting.<\/li>\n
  5. Fill Days\u00a0<\/strong>– you can add days of the week including weekends. Remember you can use the full word, or standard abbreviation and Excel will follow the series.\n

    \"Days-of-week-autofill-excel-online-courses\"<\/a>
    Days of the week including weekends<\/figcaption><\/figure><\/li>\n
  6. Fill Weekdays\u00a0<\/strong>– you can autofill working days of the week excluding weekends.\n

    \"Autofill-dates-weekends-excel-online-courses\"<\/a>
    This is very cool. I can autofill dates excluding the weekends.<\/figcaption><\/figure><\/li>\n
  7. Fill Months\u00a0<\/strong>– and you can use the full word or a standard abbreviation for the month, and Excel will autofill the sequence.\n

    \"Autofill-months-diff-formats-excel-online-courses\"<\/a>
    No matter what format I use, Autofill will follow the sequence.<\/figcaption><\/figure><\/li>\n
  8. Fill Years\u00a0<\/strong>– whichever format you are using, Excel will copy that format to fill years.\n

    \"Autofill-years-excel-online-course\"<\/a>
    Autofill years – in super-quick time<\/figcaption><\/figure><\/li>\n
  9. Fill Dates\u00a0<\/strong>– I can type in a date (whichever my preferred format is) and I can then fill the dates across a row or down a column.\n

    \"Autofill-dates-excel-online-course\"<\/a>
    Autofill dates – brilliant timesaver<\/figcaption><\/figure><\/li>\n<\/ol>\n

    You can pick up Excel skills using\u00a0excel courses online\u00a0<\/strong>and can boost your skills and your business by attending one of our instructor-led Excel courses\u00a0<\/strong>https:\/\/www.stl-training.co.uk\/microsoft\/excel-training-london.php<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    Autofill is rapidly becoming a new trick for me today. \u00a0I’ve used it to add weekdays, months of the year, and numbering columns. \u00a0But there is more to it than that and Excel offers a range of Autofill options. To get the full list of options, you need to find the Auto Fill Options\u00a0button. \u00a0In […]<\/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":[63,209],"class_list":["post-1002","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-autofill-in-excel-introduction","tag-excel-online-courses"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1002","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=1002"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1002\/revisions"}],"predecessor-version":[{"id":6739,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1002\/revisions\/6739"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}