{"id":2303,"date":"2019-08-08T16:09:27","date_gmt":"2019-08-08T22:09:27","guid":{"rendered":"https:\/\/www.brendapenman.com\/?p=2303"},"modified":"2021-11-21T15:56:12","modified_gmt":"2021-11-21T22:56:12","slug":"copy-formula-down-double-click-fill-handle","status":"publish","type":"post","link":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/","title":{"rendered":"To Copy a Formula Down in Excel, Double-Click the Fill Handle"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”3.24″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ collapsed=”off” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

\u00a0Working with large spreadsheets in Excel can be challenging, especially if you have hundreds or thousands of rows of data.\u00a0<\/p>\n

Then if you need to add formulas to each of these rows, managing this task can be even more tedious.<\/p>\n

A Quick Method is to place the formula in the top row of your data and just copy the formula down.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/AutoFill6.jpg” _builder_version=”3.26.6″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

To copy the formula down to the remaining rows in the column, the quickest and most efficient method is to move your mouse over top of the Fill Handle<\/strong>.\u00a0<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/AutoFill3.jpg” align=”center” _builder_version=”3.26.6″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

When you move your mouse over the Fill Handle, your cursor changes to<\/strong>
a black + sign. <\/strong>Then double-click the Fill Handle<\/strong>.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/AutoFill4.jpg” align=”center” _builder_version=”3.26.6″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Excel automatically looks at the surrounding data, determines the last row of data and copies the formula down to the remaining rows.\u00a0<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Let’s Try a Simple Example…<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Let’<\/span>s say you have a long list of products and you want to total the sales for each quarter.<\/span><\/p>\n

e.g. In column E (1st Quarter Sales)<\/strong>, you want to Total the sales\u00a0for each product for the months of January, February, and March.<\/span><\/p>\n

<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/AutoFill.jpg” align=”center” _builder_version=”3.26.6″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

1.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Add the formula<\/strong> in the top row of your data<\/strong>.<\/span><\/p>\n

e.g. In cell E2 (the top row of data), enter the formula to add the sales for January, February, and March<\/span><\/p>\n

=sum(B2:D2)<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/AutoFill2.jpg” align=”center” _builder_version=”3.26.6″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

2.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ custom_padding=”0px|||||” global_colors_info=”{}”]<\/p>\n

Click on the formula cell\u00a0<\/strong><\/span><\/p>\n

e.g. Click on cell E2<\/span><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ custom_padding=”0px|||||” global_colors_info=”{}”]<\/p>\n

Note:<\/strong> When you click on the cell, a small square displays <\/strong>in the bottom right corner. This is the Fill Handle<\/strong>.\u00a0\u00a0<\/span><\/p>\n

<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/AutoFill3.jpg” align=”center” _builder_version=”3.26.6″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

3.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Move your mouse over top of the Fill Handle<\/strong>. Your cursor<\/strong> changes to a black + sign<\/strong>.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/AutoFill4.jpg” align=”center” _builder_version=”3.26.6″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,3_4″ _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”|700|||||||” text_text_color=”#00a4e4″ text_font_size=”31px” text_orientation=”center” text_text_shadow_style=”preset2″ global_colors_info=”{}”]<\/p>\n

3.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”3_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Double-click<\/strong> the Fill Handle<\/strong>, to copy the formula down to the remaining rows of data in that column.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/AutoFill5.jpg” align=”center” _builder_version=”3.26.6″ global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Excel looks at the surrounding data, determines the last row of the data and copies the formula down to the last row.<\/p>\n

Even if there were empty cells to the left of the formula, Excel will still be able to determine the correct last row of the data.\u00a0<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ global_colors_info=”{}”]<\/p>\n

Note:<\/strong> Many people drag the Fill Handle to copy the formula. However, it is easy to go too far when dealing with so many rows of data.<\/p>\n

When you double-click the Fill Handle, Excel automatically determines the last row for you and copies the formula to all rows in between.\u00a0<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ custom_margin=”||0px” custom_padding=”||0px” global_colors_info=”{}”]<\/p>\n

‘Double-click the Fill Handle<\/strong>‘ is a strategic method to use when copying formulas in large spreadsheets.<\/p>\n

 <\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ custom_margin=”0px||0px” custom_padding=”0px||0px” global_colors_info=”{}”]<\/p>\n

Please share this with other Excel users and save them valuable time and maybe even some frustration.<\/p>\n

 <\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ text_text_color=”#00a4e4″ text_font_size=”22px” text_orientation=”center” custom_margin=”0px||0px” custom_padding=”0px||0px” text_text_align=”center” global_colors_info=”{}”]<\/p>\n

~ Let Microsoft Excel do the work for you. ~<\/strong><\/em><\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Submit a Commet” _builder_version=”3.25.2″ custom_margin=”0px||” custom_padding=”0px|20px||20px” global_colors_info=”{}”][et_pb_row _builder_version=”3.25″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_comments show_count=”off” _builder_version=”4.13.0″ form_field_background_color=”#ffffff” form_field_text_color=”#333333″ header_font=”Montserrat||||||||” body_font=”||||||||” form_field_font=”||||||||” form_field_text_align=”left” custom_button=”on” button_text_color=”#ffffff” button_bg_color=”#00A4E4″ button_border_color=”#00A4E4″ button_font=”Montserrat|600|||||||” button_icon=”E||divi||400″ button_icon_color=”#ffffff” button_alignment=”right” custom_margin=”0px||0px” custom_padding=”0px|0px|0px|0px” border_width_all_fields=”1px” border_color_all_fields=”#dbdbdb” border_style_all_fields=”ridge” box_shadow_style_fields=”preset3″ box_shadow_style_button=”preset2″ global_colors_info=”{}”][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Working with large spreadsheets in Excel can be challenging, especially if you have hundreds or thousands of rows of data. Then if you need to add formulas to each of these rows, managing this task can be even more tedious. Discover the quickest and most effective method to add formulas to each row of data
\n[…] <\/p>\n","protected":false},"author":1,"featured_media":3129,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"\r\n

hello<\/p>\r\n","_et_gb_content_width":"","footnotes":""},"categories":[2],"tags":[61,60,63,12,36,25,24,52,51,26,59,32,35,33,34],"class_list":["post-2303","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel","tag-autofill","tag-copy-a-formula","tag-copy-formula","tag-excel","tag-excel-2013","tag-excel-2016","tag-excel-2019","tag-excel-calculations","tag-excel-formulas","tag-excel-tips","tag-fill-handle","tag-microsoft-excel","tag-microsoft-excel-2013","tag-microsoft-excel-2016","tag-microsoft-excel-2019"],"yoast_head":"\nTo Copy a Formula Down in Excel, Double-Click the Fill Handle - Brenda Penman<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"To Copy a Formula Down in Excel, Double-Click the Fill Handle - Brenda Penman\" \/>\n<meta property=\"og:description\" content=\"Working with large spreadsheets in Excel can be challenging, especially if you have hundreds or thousands of rows of data. Then if you need to add formulas to each of these rows, managing this task can be even more tedious. Discover the quickest and most effective method to add formulas to each row of data [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/\" \/>\n<meta property=\"og:site_name\" content=\"Brenda Penman\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-08T22:09:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-21T22:56:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FillHandle0.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"717\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brenda Penman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brenda Penman\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/\"},\"author\":{\"name\":\"Brenda Penman\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"headline\":\"To Copy a Formula Down in Excel, Double-Click the Fill Handle\",\"datePublished\":\"2019-08-08T22:09:27+00:00\",\"dateModified\":\"2021-11-21T22:56:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/\"},\"wordCount\":1633,\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/FillHandle0.png\",\"keywords\":[\"AutoFill\",\"Copy a Formula\",\"Copy Formula\",\"Excel\",\"Excel 2013\",\"Excel 2016\",\"Excel 2019\",\"Excel Calculations\",\"Excel Formulas\",\"Excel Tips\",\"Fill Handle\",\"Microsoft Excel\",\"Microsoft Excel 2013\",\"Microsoft Excel 2016\",\"Microsoft Excel 2019\"],\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/\",\"name\":\"To Copy a Formula Down in Excel, Double-Click the Fill Handle - Brenda Penman\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/FillHandle0.png\",\"datePublished\":\"2019-08-08T22:09:27+00:00\",\"dateModified\":\"2021-11-21T22:56:12+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/FillHandle0.png\",\"contentUrl\":\"https:\\\/\\\/www.brendapenman.com\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/FillHandle0.png\",\"width\":1080,\"height\":717,\"caption\":\"Use Fill Handle to Copy a Formula Down\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/copy-formula-down-double-click-fill-handle\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"To Copy a Formula Down in Excel, Double-Click the Fill Handle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/\",\"name\":\"Brenda Penman\",\"description\":\"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/#\\\/schema\\\/person\\\/1ac7a1b963fb0e6f6f2e518cce9721ef\",\"name\":\"Brenda Penman\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g\",\"caption\":\"Brenda Penman\"},\"url\":\"https:\\\/\\\/www.brendapenman.com\\\/blog\\\/author\\\/mfvwwyzbgoqzie\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"To Copy a Formula Down in Excel, Double-Click the Fill Handle - Brenda Penman","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/","og_locale":"en_US","og_type":"article","og_title":"To Copy a Formula Down in Excel, Double-Click the Fill Handle - Brenda Penman","og_description":"Working with large spreadsheets in Excel can be challenging, especially if you have hundreds or thousands of rows of data. Then if you need to add formulas to each of these rows, managing this task can be even more tedious. Discover the quickest and most effective method to add formulas to each row of data [...]","og_url":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/","og_site_name":"Brenda Penman","article_published_time":"2019-08-08T22:09:27+00:00","article_modified_time":"2021-11-21T22:56:12+00:00","og_image":[{"width":1080,"height":717,"url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FillHandle0.png","type":"image\/png"}],"author":"Brenda Penman","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Brenda Penman","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/#article","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/"},"author":{"name":"Brenda Penman","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"headline":"To Copy a Formula Down in Excel, Double-Click the Fill Handle","datePublished":"2019-08-08T22:09:27+00:00","dateModified":"2021-11-21T22:56:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/"},"wordCount":1633,"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FillHandle0.png","keywords":["AutoFill","Copy a Formula","Copy Formula","Excel","Excel 2013","Excel 2016","Excel 2019","Excel Calculations","Excel Formulas","Excel Tips","Fill Handle","Microsoft Excel","Microsoft Excel 2013","Microsoft Excel 2016","Microsoft Excel 2019"],"articleSection":["Microsoft Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/","url":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/","name":"To Copy a Formula Down in Excel, Double-Click the Fill Handle - Brenda Penman","isPartOf":{"@id":"https:\/\/www.brendapenman.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/#primaryimage"},"image":{"@id":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FillHandle0.png","datePublished":"2019-08-08T22:09:27+00:00","dateModified":"2021-11-21T22:56:12+00:00","author":{"@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef"},"breadcrumb":{"@id":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/#primaryimage","url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FillHandle0.png","contentUrl":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FillHandle0.png","width":1080,"height":717,"caption":"Use Fill Handle to Copy a Formula Down"},{"@type":"BreadcrumbList","@id":"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.brendapenman.com\/blog\/"},{"@type":"ListItem","position":2,"name":"To Copy a Formula Down in Excel, Double-Click the Fill Handle"}]},{"@type":"WebSite","@id":"https:\/\/www.brendapenman.com\/blog\/#website","url":"https:\/\/www.brendapenman.com\/blog\/","name":"Brenda Penman","description":"Learn Microsoft Office - Excel, Word, PowerPoint, Outlook, OneNote","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.brendapenman.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.brendapenman.com\/blog\/#\/schema\/person\/1ac7a1b963fb0e6f6f2e518cce9721ef","name":"Brenda Penman","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12d4d8be4a4ca51ed4f62b1be1801d1361d03486de3abeb43b442ff0596828e3?s=96&d=mm&r=g","caption":"Brenda Penman"},"url":"https:\/\/www.brendapenman.com\/blog\/author\/mfvwwyzbgoqzie\/"}]}},"_links":{"self":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/2303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/comments?post=2303"}],"version-history":[{"count":5,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/2303\/revisions"}],"predecessor-version":[{"id":3510,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/posts\/2303\/revisions\/3510"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media\/3129"}],"wp:attachment":[{"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/media?parent=2303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/categories?post=2303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.brendapenman.com\/blog\/wp-json\/wp\/v2\/tags?post=2303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}