{"id":244,"date":"2022-08-16T20:11:25","date_gmt":"2022-08-16T20:11:25","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=244"},"modified":"2024-04-12T22:02:06","modified_gmt":"2024-04-12T22:02:06","slug":"copy-formula-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/copy-formula-in-excel\/","title":{"rendered":"How to copy formula in Excel? How to copy formula down in excel column?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"244\" class=\"elementor elementor-244\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4439c4f6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4439c4f6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5ab29a1\" data-id=\"5ab29a1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1c76c8e5 elementor-widget elementor-widget-text-editor\" data-id=\"1c76c8e5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div data-id=\"201e485\" data-element_type=\"widget\" data-widget_type=\"theme-post-title.default\"><div><h1><span style=\"font-size: 15px; font-style: inherit; font-weight: inherit; color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; background-color: var(--ast-global-color-5);\">Copy Formula in Excel marks a pivotal step in your journey to becoming an Excel maestro. This indispensable skill not only streamlines your workflow but also ensures consistency and accuracy across your datasets. As you harness the power of copying formulas, you open up a world of efficiency, allowing you to replicate success across multiple cells, worksheets, and workbooks with ease. Embrace the art of copying formulas in Microsoft Excel, and watch as your productivity soars, your data comes to life, and your spreadsheets become a testament to precision and expertise.<\/span><\/h1><\/div><\/div><div data-id=\"3db31e1\" data-element_type=\"widget\" data-widget_type=\"theme-post-content.default\"><p>In this tutorial, we will describe how to copy a formula in Excel.\u00a0<\/p><p><b>Step-1:\u00a0<\/b>Prepare a simple data table<\/p><p><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-1.png\" sizes=\"(max-width: 441px) 100vw, 441px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-1.png 441w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-1-300x154.png 300w\" alt=\"Copy excel Formula\" width=\"441\" height=\"227\" \/><\/p><p><b>Step-2:\u00a0<\/b>Set\u00a0 an original formula in cell C2, outlined below:\u00a0<\/p><p><img decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-2.png\" sizes=\"(max-width: 485px) 100vw, 485px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-2.png 485w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-2-300x187.png 300w\" alt=\"Copy excel formula\" width=\"485\" height=\"302\" \/><\/p><p><b>Step-3:\u00a0<\/b>Select cell C-2, outlined below:<\/p><p><img decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-3.png\" sizes=\"(max-width: 535px) 100vw, 535px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-3.png 535w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-3-300x146.png 300w\" alt=\"Copy excel formula\" width=\"535\" height=\"260\" \/><\/p><p><strong>Step-4:\u00a0<\/strong>Follow the below process to copy the formula from cell C2 to C3 and C4<\/p><ul><li>Select cell C2<\/li><li>Press CTRL+C to quickly copy formula<\/li><\/ul><p>Or Select copy from the home menu, outlined below<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-4.png\" sizes=\"(max-width: 606px) 100vw, 606px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-4.png 606w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-4-300x112.png 300w\" alt=\"Copy excel formula\" width=\"606\" height=\"227\" \/><\/p><ul><li>Click one cell where you want to paste the formula. Click C3<\/li><li>To quickly paste the formula with its formatting, press CTRL+V.<\/li><\/ul><p>Or Select paste option from home menu to paste in new cell, outlined below<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-5.png\" sizes=\"(max-width: 361px) 100vw, 361px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-5.png 361w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-5-283x300.png 283w\" alt=\"Copy excel formula\" width=\"361\" height=\"383\" \/><\/p><p>Result outlined below<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-6.png\" sizes=\"(max-width: 573px) 100vw, 573px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-6.png 573w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-6-300x136.png 300w\" alt=\"Copy excel formula\" width=\"573\" height=\"260\" \/><\/p><h2><strong>How to Copy a Formula in Excel to entire column (by double click plus sign (+) in the cell)?<\/strong><\/h2><p><strong>Step-1:\u00a0<\/strong>Prepare a data table:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-7.png\" sizes=\"(max-width: 442px) 100vw, 442px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-7.png 442w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-7-300x155.png 300w\" alt=\"Copy excel formula-8\" width=\"442\" height=\"228\" \/><\/p><p><b>Step-2:\u00a0<\/b>Set a formula in cell C2, outlined below<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/copy-excel-formula-8.png\" sizes=\"(max-width: 478px) 100vw, 478px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/copy-excel-formula-8.png 478w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/copy-excel-formula-8-300x190.png 300w\" alt=\"Copy excel formula\" width=\"478\" height=\"302\" \/><\/p><p><b>Step-3:\u00a0<\/b>Position the cursor to the lower right corner of the cell C2, wait until it turns into the plus sign, and then double-click the plus<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-9.png\" sizes=\"(max-width: 638px) 100vw, 638px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-9.png 638w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-9-300x140.png 300w\" alt=\"Copy excel formula\" width=\"638\" height=\"297\" \/><\/p><p>Result outlined below<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-10.png\" sizes=\"(max-width: 631px) 100vw, 631px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-10.png 631w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-10-300x138.png 300w\" alt=\"Copy excel formula\" width=\"631\" height=\"290\" \/><\/p><h2><strong>How to Copy Excel Formula Down a Column Using Fill Handle?<\/strong><\/h2><p><strong>Step-1:\u00a0<\/strong>Prepare a data table<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-11.png\" sizes=\"(max-width: 437px) 100vw, 437px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-11.png 437w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-11-300x155.png 300w\" alt=\"Copy excel formula\" width=\"437\" height=\"226\" \/><\/p><p><b>Step-2:\u00a0<\/b>Set a formula in cell C2<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-12.png\" sizes=\"(max-width: 478px) 100vw, 478px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-12.png 478w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-12-300x187.png 300w\" alt=\"Copy excel formula\" width=\"478\" height=\"298\" \/><\/p><p><strong>Step-3:\u00a0<\/strong>Position the cursor to the lower right corner of the cell C2, wait until it turns into a thick black cross. which is called the\u00a0<strong>Fill handle.<\/strong><\/p><ul><li>Hold and drag the fill handle down the column over the cells where you want to copy the formula. Drag C2 to C5, outlined below:<\/li><\/ul><p>Result outlined below<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-13.png\" sizes=\"(max-width: 636px) 100vw, 636px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-13.png 636w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-13-300x138.png 300w\" alt=\"Copy excel formula\" width=\"636\" height=\"292\" \/><\/p><h2><strong>Copy an Excel Formula without Changing References &#8211; Absolute Reference and Relative Cell Reference<\/strong><\/h2><p><strong>Relative Reference:\u00a0<\/strong>When you duplicate a cell using a formula, you\u2019ll see that the cell references in the formula also move an equivalent number of cells up and down. A relative reference is the name given to this kind of cell reference.<\/p><p><strong>Step-1:\u00a0<\/strong>Formula for\u00a0<strong>Relative\u00a0<\/strong>reference:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-14.png\" sizes=\"(max-width: 601px) 100vw, 601px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-14.png 601w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-14-300x171.png 300w\" alt=\"Copy excel formula\" width=\"601\" height=\"343\" \/><\/p><p><strong>Step-2:\u00a0<\/strong>Formula output for\u00a0<strong>Relative<\/strong>\u00a0reference:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-15.png\" sizes=\"(max-width: 605px) 100vw, 605px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-15.png 605w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-15-300x184.png 300w\" alt=\"Copy excel formula\" width=\"605\" height=\"371\" \/><\/p><p><strong>Step-3:\u00a0<\/strong>Copy formula with\u00a0<strong>Relative<\/strong>\u00a0reference:<\/p><p>When we copy (Ctrl + C) the formula in the image above from cell B8, and paste (Ctrl + V) it into another cell D8, you\u2019ll notice that changing cell references from the B column to the D column, so the total is different. See the Result outlined below:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-16.png\" sizes=\"(max-width: 611px) 100vw, 611px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-16.png 611w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-16-300x152.png 300w\" alt=\"Copy excel formula\" width=\"611\" height=\"310\" \/><\/p><p><strong>Note:<\/strong>\u00a0you can use plus sign to drag the formula or double-click the plus to move the relative reverence formula to target cell. Also, you can use Fill handle to copy formula in targeted cell.<\/p><p><strong>Absolute Reference:\u00a0<\/strong>Use absolute references if you don\u2019t want Excel to alter the cell references when you copy cells. Insert a dollar sign ($) before both sections of the cell reference in the formula you want to freeze to generate an absolute reference. See the process outlined below:<\/p><p><strong>Step-1:\u00a0<\/strong>Formula for\u00a0<strong>Absolute<\/strong>\u00a0reference:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-17.png\" sizes=\"(max-width: 577px) 100vw, 577px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-17.png 577w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-17-300x164.png 300w\" alt=\"Copy excel formula\" width=\"577\" height=\"315\" \/><\/p><p><strong>Step-2:\u00a0<\/strong>Formula output for\u00a0<strong>Absolute<\/strong>\u00a0reference:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-18.png\" sizes=\"(max-width: 602px) 100vw, 602px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-18.png 602w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-18-300x185.png 300w\" alt=\"Copy excel formula\" width=\"602\" height=\"372\" \/><\/p><p><strong>Step-3:\u00a0<\/strong>Copy formula with\u00a0<strong>Absolute<\/strong>\u00a0reference:<\/p><p>When we copy (Ctrl + C) the formula in the image above from cell B8, and paste (Ctrl + V) it into another cell D8, you\u2019ll notice that the cell formula change from the B column to the D column, but total result is same. See the Result outlined below:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-19.png\" sizes=\"(max-width: 695px) 100vw, 695px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-19.png 695w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-19-300x177.png 300w\" alt=\"Copy excel formula\" width=\"695\" height=\"411\" \/><\/p><p><strong>Note:<\/strong>\u00a0you can use plus sign to drag the formula or double-click the plus to move the relative reverence formula to target cell. Also, you can use Fill handle to copy formula in targeted cell.<\/p><h2><strong>How to Copy Exact Formula to Other Cells in Excel?<\/strong><\/h2><p><strong>Step-1:\u00a0<\/strong>Use ENTER to Copy Exact Formula in selected Cells, outlined below:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-20.png\" sizes=\"(max-width: 622px) 100vw, 622px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-20.png 622w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-20-300x182.png 300w\" alt=\"Copy excel formula\" width=\"622\" height=\"377\" \/><\/p><p>The formula is copied exactly to cell D8.<strong><u>\u00a0<\/u><\/strong><\/p><h2><strong>Use CTRL+ENTER to Copy a Formula into Multiple Cells?<\/strong><\/h2><p>Copy and paste a formula. Pressing CTRL+ENTER we can make an exact copy of the same formula in multiple cells simultaneously. See another way to copy and paste formula:<\/p><ul><li>Go to Cell D5.<\/li><li>Copy the formula from the formula bar using CTRL+C.<\/li><\/ul><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-21.png\" sizes=\"(max-width: 585px) 100vw, 585px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-21.png 585w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-21-300x172.png 300w\" alt=\"Copy excel formula\" width=\"585\" height=\"335\" \/><\/p><ul><li>Now, select multiple cells by pressing the\u00a0<strong>CTRL button.<\/strong><\/li><li>After the selection of cells, press the\u00a0<strong>F2 button<\/strong>.<\/li><\/ul><p>Cells are in editable mood now. Paste the formula now, by pressing\u00a0<strong>CTRL+V<\/strong>, outlined below:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-22.png\" sizes=\"(max-width: 638px) 100vw, 638px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-22.png 638w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-22-300x166.png 300w\" alt=\"Copy excel formula\" width=\"638\" height=\"352\" \/><\/p><ul><li>Now, press\u00a0<strong>CTRL+ENTER<\/strong>\u00a0instead of the ENTER only. See the Result outlined below:<\/li><\/ul><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-23.png\" sizes=\"(max-width: 652px) 100vw, 652px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-23.png 652w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-23-300x144.png 300w\" alt=\"Copy excel formula\" width=\"652\" height=\"313\" \/><\/p><p>All the selected cells are exactly copied with the copied formula.<\/p><h2><strong>How to move a formula in Excel?<\/strong><\/h2><p><strong>Moving a formula:<\/strong>\u00a0No matter the sort of cell reference you employ, the references within a formula remain the same when you relocate or move it.<\/p><p><strong>Step-1:\u00a0<\/strong>prepare a table with formula, outlined below:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-24.png\" sizes=\"(max-width: 581px) 100vw, 581px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-24.png 581w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-24-300x166.png 300w\" alt=\"Copy excel formula\" width=\"581\" height=\"321\" \/><\/p><p><strong>Step-2: S<\/strong>elect the cell that contains the formula that you want to move. In the Clipboard group of the Home tab, click Cut, outline below:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-25.png\" sizes=\"(max-width: 702px) 100vw, 702px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-25.png 702w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-25-300x232.png 300w\" alt=\"Copy excel formula\" width=\"702\" height=\"542\" \/><\/p><p>Paste in cell D8, press CTRL+V, result outline below:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-26.png\" sizes=\"(max-width: 517px) 100vw, 517px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-26.png 517w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-26-300x160.png 300w\" alt=\"Copy excel formula\" width=\"517\" height=\"275\" \/><\/p><p>Formula moves to cell D8 from B8.<\/p><p><strong>Step-3:\u00a0<\/strong>You can also move formulas by dragging the border of the selected cell to the upper-left cell of the paste area. This will replace any existing data. outlined below:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-27.png\" sizes=\"(max-width: 603px) 100vw, 603px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-27.png 603w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-27-300x222.png 300w\" alt=\"Copy excel formula\" width=\"603\" height=\"446\" \/><\/p><p>Drag to cell D8, result outlined below:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/copy-excel-formula-28.png\" sizes=\"(max-width: 522px) 100vw, 522px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/copy-excel-formula-28.png 522w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/copy-excel-formula-28-300x160.png 300w\" alt=\"Copy excel formula\" width=\"522\" height=\"278\" \/><\/p><p>Formula moves to cell D8 from B8.<\/p><h2><strong>Copy a formula to non-adjacent cells\/ranges?<\/strong><\/h2><p>Naturally, the fill handle is the quickest method for copying Excel formulas. But what if you want to transfer your Excel formula into a range of cells that aren\u2019t adjacent to one another or past the end of the source data? Simply copy cell to another and paste like you always have:<\/p><ul><li>Click the cell with the formula to select it. Select Cell C1 outlined below:<\/li><\/ul><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-29.png\" sizes=\"(max-width: 575px) 100vw, 575px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-29.png 575w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-29-300x177.png 300w\" alt=\"Copy excel formula\" width=\"575\" height=\"340\" \/><\/p><ul><li>Press Ctrl + C to copy the formula.<\/li><li>Select a cell or a range of cells where you want to paste the formula (to select non-adjacent ranges, press and hold the Ctrl key). See the selection outlined below:<\/li><\/ul><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-30.png\" sizes=\"(max-width: 503px) 100vw, 503px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-30.png 503w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-30-300x211.png 300w\" alt=\"Copy excel formula\" width=\"503\" height=\"353\" \/><\/p><ul><li>Press Ctrl + V to paste the formula.<\/li><li>Press Enter to complete the pasted formulas. See the result outlined below:<\/li><\/ul><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-31.png\" sizes=\"(max-width: 590px) 100vw, 590px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-31.png 590w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-31-300x232.png 300w\" alt=\"Copy excel formula\" width=\"590\" height=\"457\" \/><\/p><h2><strong>Using Find and Replace to copy formula in Excel without Changing Cell<\/strong><\/h2><p><strong>Step-1:\u00a0<\/strong>Prepare a data table with information and formula outlined below:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-32.png\" sizes=\"(max-width: 621px) 100vw, 621px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-32.png 621w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-32-300x165.png 300w\" alt=\"Copy excel formula\" width=\"621\" height=\"342\" \/><\/p><p>The formula result outlined below:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-33.png\" sizes=\"(max-width: 607px) 100vw, 607px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-33.png 607w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-33-300x175.png 300w\" alt=\"Copy excel formula\" width=\"607\" height=\"355\" \/><\/p><p><strong>Step-2:\u00a0<\/strong>Select the cells that have the formula across that you want to copy, outlined below.<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-34.png\" sizes=\"(max-width: 697px) 100vw, 697px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-34.png 697w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-34-300x164.png 300w\" alt=\"Copy excel formula\" width=\"697\" height=\"382\" \/><\/p><p><strong>Step-3:\u00a0<\/strong>Go to Home \u2013&gt; Find &amp; Select \u2013&gt; Replace. Or Press Control + H to open find and replace window:<\/p><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-35.png\" sizes=\"(max-width: 793px) 100vw, 793px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-35.png 793w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-35-300x98.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-35-768x250.png 768w\" alt=\"Copy excel formula\" width=\"793\" height=\"258\" \/><\/p><p><strong>Step-4:<\/strong>\u00a0In the Find and Replace dialog box:<\/p><ul><li>In the \u2018Find what\u2019 field,\u00a0<strong>enter =<\/strong><\/li><li>In the \u2018Replace with\u2019 field,\u00a0<strong>enter #,\u00a0<\/strong>outlined below:<\/li><\/ul><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-36.png\" sizes=\"(max-width: 523px) 100vw, 523px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-36.png 523w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-36-300x158.png 300w\" alt=\"Copy excel formula\" width=\"523\" height=\"276\" \/><\/p><ul><li>Click\u00a0<strong>OK<\/strong>. This will\u00a0<strong>replace all<\/strong>\u00a0the equal to (=) sign with the hash (#) sign. outlined below:<\/li><\/ul><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-37.png\" sizes=\"(max-width: 612px) 100vw, 612px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-37.png 612w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-37-300x173.png 300w\" alt=\"Copy excel formula\" width=\"612\" height=\"353\" \/><\/p><ul><li>Copy these cells D1 to D10, use CTRL + C to copy.<\/li><li>Paste it in the destination cells F1, use CTRL + V to paste. Result outlined below:<\/li><\/ul><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-38.png\" sizes=\"(max-width: 645px) 100vw, 645px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-38.png 645w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-38-300x90.png 300w\" alt=\"Copy Formula in Excel\" width=\"645\" height=\"193\" \/><\/p><ul><li>Go to Home \u2013&gt; Find &amp; Replace \u2013&gt; Replace or press Control + H to open Find and Replace dialog box.<\/li><li>In the Find and Replace dialog box:<\/li><li>In the \u2018<strong>Find what\u2019<\/strong>\u00a0field,\u00a0<strong>enter #<\/strong><\/li><li>In the\u00a0<strong>\u2018Replace with\u2019<\/strong>\u00a0field,\u00a0<strong>enter =,\u00a0<\/strong>outlined below:<\/li><\/ul><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-40.png\" sizes=\"(max-width: 528px) 100vw, 528px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-40.png 528w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-40-300x172.png 300w\" alt=\"Copy Formula in Excel\" width=\"528\" height=\"303\" \/><\/p><ul><li>Click\u00a0<strong>OK<\/strong>. This will\u00a0<strong>replace all<\/strong>\u00a0the equal to (#) sign with the hash (=) sign. This will convert the text back into the formula and you will get the result, outlined below:<\/li><\/ul><p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-41.png\" sizes=\"(max-width: 577px) 100vw, 577px\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-41.png 577w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Copy-excel-formula-41-300x126.png 300w\" alt=\"Copy Formula in Excel\" width=\"577\" height=\"243\" \/><\/p><article><div><div><h2>An exact Copy of Multiple Formulas in Excel<\/h2><ul><li><strong>Select Formulas<\/strong>: Click and drag to select the cells containing the formulas you want to copy.<\/li><li><strong>Copy Command<\/strong>: Use the keyboard shortcut <code>Ctrl+C<\/code> or right-click and select &#8216;Copy&#8217; from the context menu.<\/li><li><strong>Select Destination<\/strong>: Click on the cell where you want to start pasting the formulas, or select a range of cells matching the original size.<\/li><li><strong>Paste Formulas<\/strong>: Use the keyboard shortcut <code>Ctrl+V<\/code> or right-click and select &#8216;Paste Formulas&#8217; from the paste options to retain the formula logic.<\/li><li><strong>Check References<\/strong>: Ensure that the cell references in the copied formulas are correct and adjust if necessary to maintain accuracy.<\/li><\/ul><p>For ready-to-use Dashboard Templates:<\/p><ol><li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li><li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li><li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li><li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li><\/ol><\/div><\/div><\/article><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Copy Formula in Excel marks a pivotal step in your journey to becoming an Excel maestro. This indispensable skill not only streamlines your workflow but also ensures consistency and accuracy across your datasets. As you harness the power of copying formulas, you open up a world of efficiency, allowing you to replicate success across multiple &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/copy-formula-in-excel\/\"> <span class=\"screen-reader-text\">How to copy formula in Excel? How to copy formula down in excel column?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[41],"tags":[42,43,45],"class_list":["post-244","post","type-post","status-publish","format-standard","hentry","category-copy-excel-formula","tag-copy-excel-formula","tag-excel-formula-copy","tag-how-to-copy-formula-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=244"}],"version-history":[{"count":12,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/244\/revisions"}],"predecessor-version":[{"id":8891,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/244\/revisions\/8891"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}