{"id":242,"date":"2014-11-25T20:01:15","date_gmt":"2014-11-25T20:01:15","guid":{"rendered":"http:\/\/www.johnfperry.com\/?p=242"},"modified":"2014-11-25T20:01:15","modified_gmt":"2014-11-25T20:01:15","slug":"excel-extend-range-cells","status":"publish","type":"post","link":"https:\/\/johnfperry.com\/?p=242","title":{"rendered":"EXCEL &#8211; extend range cells"},"content":{"rendered":"<pre>If you want to extend your range down you can do this by calculating the first 2 cells with your formula and then highlighting them. You now grap the little square on the bottom right of the highlighted area and drag that down, across or both.\n\nIf you have a specific cell (e.g. D2) which you wish for to remain in all the cells you extend your range to then in your 2 initial cell calculations use the following:\n\nExntending Down\n\n=G2*D$2\n=G3*D$2\nExtending Across\n\n=G2*$D2\n=H2*$D2\nExtending Down and Across\n\nUse $D$2 \n<\/pre>\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/5372727\/applying-a-formula-to-all-cells-in-a-column-not-just-one-at-a-time\">Here&#8217;s <\/a>the original source.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you want to extend your range down you can do this by calculating the first 2 cells with your&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[4],"tags":[],"class_list":["post-242","post","type-post","status-publish","format-standard","hentry","category-excel"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/johnfperry.com\/index.php?rest_route=\/wp\/v2\/posts\/242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/johnfperry.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/johnfperry.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/johnfperry.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/johnfperry.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=242"}],"version-history":[{"count":0,"href":"https:\/\/johnfperry.com\/index.php?rest_route=\/wp\/v2\/posts\/242\/revisions"}],"wp:attachment":[{"href":"https:\/\/johnfperry.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/johnfperry.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/johnfperry.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}