{"id":717,"date":"2019-05-30T19:13:29","date_gmt":"2019-05-31T00:13:29","guid":{"rendered":"http:\/\/www.iqaccountingsolutions.com\/blog\/?p=717"},"modified":"2019-07-24T15:14:04","modified_gmt":"2019-07-24T20:14:04","slug":"using-the-fill-command-in-excel","status":"publish","type":"post","link":"https:\/\/www.iqaccountingsolutions.com\/blog\/using-the-fill-command-in-excel\/","title":{"rendered":"Using the Fill Command In Excel"},"content":{"rendered":"<p>Excel\u2019s Fill command lets you fill an adjacent group of cells with the same text or numbers, or with text or numbers that form a series. In its simplest form it\u2019s like a faster version of copy and paste. For example, enter a name in cell A1, then highlight cells A1 through A5 and press <em>Ctrl+D<\/em> (the keyboard shortcut for Fill Down) and all the selected cells will be filled in with the name from A1<strong>.<\/strong> But it can do much more.<\/p>\n<p>First let\u2019s talk about the mechanics of using Fill, then we\u2019ll get into what else it can do. There are several ways to access <em>Fill<\/em>:<\/p>\n<ul>\n<li><strong>Keyboard Shortcuts<\/strong> \u2013 <em>Ctrl+D<\/em> is the shortcut for Fill Down. <em>Ctrl+R<\/em> is the shortcut for Fill Right. Both require you to first highlight a range of cells, starting will the cell containing the text or numbers you want copied to the other cells.<\/li>\n<li><strong>Fill Button<\/strong> \u2013 With the Home tab selected on the ribbon you will find the <em>Fill<\/em> button in the Editing group at the right end of the ribbon. Clicking it will give you options to fill Down, Right, Up, or Left, which are self explanatory, as well as <em>Across Worksheets<\/em>, Series, Justify, and Flash Fill. To use the Across Worksheets option, select some cells on the current worksheet, then <em>Shift+Click<\/em> or<em> Ctrl+Click<\/em> on one or more tabs to select multiple worksheets. Then choose <em>Fill<\/em> \u2013 <em>Across Worksheets <\/em>to have the selected cells copied to the other worksheets. I\u2019ll explain the Series option later in this tip and Justify will be covered another time.<\/li>\n<li><strong>Fill Handle<\/strong> \u2013 The fill handle is the small black square at the bottom right corner of the bold outline around the currently selected cell(s). Dragging it is the same as using Fill or Fill Series, depending on the situation. Dragging it with the right mouse button will present you with a menu of options. Double-clicking it will automatically do a <em>Fill Down<\/em> as far as the contents of the adjacent column without you having to select the destination cells.<\/li>\n<\/ul>\n<p>As I mentioned before, the basic fill command is like a streamlined version of copy and paste. You highlight one or more cells along with the cells you want to fill in, then select the appropriate Fill-Down\/Right\/Up\/Left\/Across Worksheet command. That\u2019s nice but the Fill Series option let\u2019s you do much more.<\/p>\n<p>A series can be numbers, dates, days, months, etc. Excel just needs to be able to determine the pattern for the series. Some series are programed into Excel and are automatically recognized when using the fill handle or the Fill \u2013 Series button, such as:<\/p>\n<ul>\n<li>Months \u2013 Enter January and Excel with fill with February, March, etc. Enter Jan and you will get Feb, Mar, etc.<\/li>\n<li>Days of the Week \u2013 Again use the full name (Monday) or the abbreviation (Mon)<\/li>\n<li>Ordinals \u2013 1st, 2nd, 3rd, etc<\/li>\n<li>Text followed by a number \u2013 The number will be incremented as in Year 1, Year 2, Year 3\u2026<\/li>\n<li>Dates \u2013 dragging the fill handle will increment the day, but using the Fill \u2013 Series button will let you choose Day, Weekday, Month, or Year.<\/li>\n<\/ul>\n<p>To fill a series of numbers you have to tell Excel how you want the numbers incremented. If you enter 1 in a cell and drag the fill handle, it will fill all the selected cells with 1. But if you enter 1 in a cell, then 2 in the cell below it, highlight both cells and drag the fill handle down, it will increment the number in each cell by one. If you did the same thing using 10 and 20 instead of 1 and 2, Excel would continue the series as 30, 40, etc.<\/p>\n<p>If you use the Fill \u2013 Series button instead of the fill handle, you can enter just your starting number, then click <em>Fill <\/em>and choose <em>Series<\/em>. Here you can enter a Step Value (the number added to each cell in the fill range). You can also set a Stop Value if you want to stop filling once a certain number is reached. If you didn\u2019t highlight a fill area before clicking the Fill button, you can also choose to have your series filled in a row (will fill to the right) or column (will fill down).\u00a0 If you set the series Type to <em>Growth<\/em> instead of <em>Linear<\/em>, each cell in the series will be multiplied by the step value. Set the Type to <em>Date<\/em> and the <em>Date Unit<\/em> section allows you to choose whether the step value applies to the Day, Weekday, Month, or Year.<\/p>\n<p>Try out all three methods and you will quickly see how Fill works. Don\u2019t forget to try right-dragging the fill handle as a quick way to get to the series options.<\/p>\n<p>Next month I\u2019ll explain how you can create your own custom series such as list of departments or sales reps.<\/p>\n<p>&nbsp;<\/p>\n<p><iframe loading=\"lazy\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/KAQI-tIQ26Y?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u2019s Fill command lets you fill an adjacent group of cells with the same text or numbers, or with text or numbers that form a series. In its simplest form it\u2019s like a faster version of copy and paste. For example, enter a name in cell A1, then highlight cells A1 through A5 and press [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9,5],"tags":[],"_links":{"self":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/717"}],"collection":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=717"}],"version-history":[{"count":5,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/717\/revisions"}],"predecessor-version":[{"id":2420,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/717\/revisions\/2420"}],"wp:attachment":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}