{"version":"1.0","provider_name":"Brenda Penman","provider_url":"https:\/\/www.brendapenman.com\/blog","author_name":"Brenda Penman","author_url":"https:\/\/www.brendapenman.com\/blog\/author\/mfvwwyzbgoqzie\/","title":"To Copy a Formula Down in Excel, Double-Click the Fill Handle - Brenda Penman","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"Prbc9S5gDY\"><a href=\"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/\">To Copy a Formula Down in Excel, Double-Click the Fill Handle<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.brendapenman.com\/blog\/copy-formula-down-double-click-fill-handle\/embed\/#?secret=Prbc9S5gDY\" width=\"600\" height=\"338\" title=\"&#8220;To Copy a Formula Down in Excel, Double-Click the Fill Handle&#8221; &#8212; Brenda Penman\" data-secret=\"Prbc9S5gDY\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/www.brendapenman.com\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","thumbnail_url":"https:\/\/www.brendapenman.com\/wp-content\/uploads\/2018\/02\/FillHandle0.png","thumbnail_width":1080,"thumbnail_height":717,"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 [...]"}