{"id":264354,"date":"2024-03-13T20:06:49","date_gmt":"2024-03-13T19:06:49","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=264354"},"modified":"2026-11-09T15:43:25","modified_gmt":"2026-11-09T14:43:25","slug":"copiar-formula-excel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/excel-functions\/copy-formula-excel\/","title":{"rendered":"Como copiar uma f\u00f3rmula no Excel? 9 m\u00e9todos f\u00e1ceis"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>When working in a spreadsheet, there are many reasons why you may need to copy a formula to single or multiple cells. These may be adjacent &#8211; column or row &#8211; or located in different parts of the spreadsheet. In any case, Microsoft Excel offers multiple options for copying and pasting formulas and other parts or features of the cell\u2019s contents.<\/p>\n<p>In this guide, you will learn how to copy and paste a formula to a single cell, an entire column or row, or non-adjacent cells. First, you will review absolute vs. relative referencing before learning nine different methods for copying formulas in Excel: using simple paste, using special paste (formulas), pasting to multiple non-adjacent cells, converting a range to an Excel table to copy the formula automatically, using the array formula shortcut, using the fill tool, double-clicking or dragging the fill handle, and using a keyboard shortcut.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;absolute-vs-relative-referencing-in-form&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Absolute vs. relative referencing in formulas<\/h2>\n<p>The type of referencing you use determines whether the references change when you copy a formula. In some cases, you want the references to be relative so that they will adapt to refer to whichever row or column to which you are copying. However, sometimes you need to keep the column or row fixed with absolute referencing, and sometimes you need the formula to remain anchored to the original cells.<\/p>\n<h3>Absolute referencing<\/h3>\n<p>To ensure that you refer to a specific cell, use absolute referencing for the column and row. Regardless of where you copy the formula, it will always refer to those specific cells. The dollar signs work the same way when you set an <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/absolute-cell-reference\/\">absolute cell reference in Google Sheets<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-excel-absolute-referencing.webp&#8221; alt=&#8221;How to copy formula in Excel \u2014 =$A$1*$B$1 in cell D2 under the absolute referencing label&#8221; title_text=&#8221;=$A$1*$B$1 in cell D2 under the absolute referencing label&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Mixed referencing<\/h3>\n<p>To ensure that the column is fixed but the formula adjusts to the row it\u2019s copied to, use absolute referencing for the column and relative for the row.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-excel-fixed-column.webp&#8221; alt=&#8221;How to copy formula in Excel \u2014 =$A1*$B1 in cell E2 under the fixed column label&#8221; title_text=&#8221;=$A1*$B1 in cell E2 under the fixed column label&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>To fix the row and not the column, use absolute referencing for the row only.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-excel-fixed-row.webp&#8221; alt=&#8221;How to copy formula in Excel \u2014 =A$1*B$1 in cell F2 under the fixed row label&#8221; title_text=&#8221;=A$1*B$1 in cell F2 under the fixed row label&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Relative referencing<\/h3>\n<p>Finally, use relative referencing for both to allow the column and row to change relative to the cell\u2019s location.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-excel-relative-referencing.webp&#8221; alt=&#8221;How to copy formula in Excel \u2014 =A1*B1 in cell G2 under the relative label&#8221; title_text=&#8221;=A1*B1 in cell G2 under the relative label&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-to-copy-and-paste-a-formula-in-excel&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to copy and paste a formula in Excel?<\/h2>\n<p>There are various ways to copy and paste a formula in Microsoft Excel. You can copy it using any of the available methods, including right-clicking to see the menu or using the shortcuts: Ctrl + c (Windows) or Cmd + c (Mac).<\/p>\n<p>Select the cells where you want to paste.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-and-paste-formula-excel-select-paste-range.webp&#8221; alt=&#8221;Copy and paste a formula in Excel \u2014 copied row D2:G2 with cells D3:G5 selected below it&#8221; title_text=&#8221;Copied row D2:G2 with cells D3:G5 selected below it&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Use the shortcut &#8211; Ctrl + v or Cmd + v &#8211; or right-click and select paste. This will reproduce the cell exactly, including the formula and the format. However, the type of referencing will depend on the original cell. Using relative referencing in the original formula will adapt the references to the new location.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-and-paste-formula-excel-simple-paste.webp&#8221; alt=&#8221;Copy and paste a formula in Excel \u2014 formulas pasted into rows 3 to 5 with the references adjusted&#8221; title_text=&#8221;Formulas pasted into rows 3 to 5 with the references adjusted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Special paste options<\/h3>\n<p>If you want to keep the formula only, use \u2018Paste Special\u2019 and choose \u2018Formulas\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-and-paste-formula-excel-paste-formulas.webp&#8221; alt=&#8221;Copy and paste a formula in Excel \u2014 right-click Paste Special submenu with Formulas highlighted&#8221; title_text=&#8221;Right-click Paste Special submenu with Formulas highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>However, as you can see in the screenshot below, Microsoft Excel features a variety of special options for pasting.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-and-paste-formula-excel-paste-special-menu.webp&#8221; alt=&#8221;Copy and paste a formula in Excel \u2014 Paste Special submenu with a callout pointing to Paste Special&#8221; title_text=&#8221;Paste Special submenu with a callout pointing to Paste Special&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Click \u2018Paste Special\u2026\u2019 to see even more options.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-and-paste-formula-excel-paste-special-dialog.webp&#8221; alt=&#8221;Copy and paste a formula in Excel \u2014 Paste Special dialog with Paste and Operation options&#8221; title_text=&#8221;Paste Special dialog with Paste and Operation options&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-to-copy-a-formula-to-non-adjacent-ce&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to copy a formula to non-adjacent cells in Excel?<\/h2>\n<p>Follow the steps below to copy formulas to non-adjacent cells.<\/p>\n<p><strong>1.<\/strong> Copy the cell with the formula. Remember to use absolute referencing if you want the formula to remain the same.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-non-adjacent-cells-excel-copy.webp&#8221; alt=&#8221;Copy a formula to non-adjacent cells in Excel \u2014 SUM formula in B2 with Copy selected in the right-click menu&#8221; title_text=&#8221;SUM formula in B2 with Copy selected in the right-click menu&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Select the first cell and hold down Ctrl or Cmd while selecting the rest.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-non-adjacent-cells-excel-select.webp&#8221; alt=&#8221;Copy a formula to non-adjacent cells in Excel \u2014 cells D2, F2, H2 and J2 selected&#8221; title_text=&#8221;Cells D2, F2, H2 and J2 selected&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> Press Ctrl + v or Cmd + v to copy the contents to the selected cells.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-non-adjacent-cells-excel-paste.webp&#8221; alt=&#8221;Copy a formula to non-adjacent cells in Excel \u2014 the SUM result pasted into D2, F2, H2 and J2&#8243; title_text=&#8221;The SUM result pasted into D2, F2, H2 and J2&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-to-copy-a-formula-down-a-column-in-e&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to copy a formula down a column in Excel?<\/h2>\n<p>There are multiple ways to copy a formula to a column or row in Microsoft Excel. Below, you will learn how to use six different methods.<\/p>\n<h3>Create Excel table to add formula to entire column automatically<\/h3>\n<p>The simplest way to ensure that your formula is automatically adjusted and copied down to the last row is to turn your range of data into an Excel table.<\/p>\n<p><strong>1.<\/strong> Select any cell in the range and press Ctrl + t (Windows) or Cmd + t (Mac).<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-create-table.webp&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 Create Table dialog for range A1:B20 with headers ticked&#8221; title_text=&#8221;Create Table dialog for range A1:B20 with headers ticked&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Type your formula into the first cell of the column where you want the results. In this case, I want to multiply the value in the amount column by 0.1 (10%).<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-table-formula.webp&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 amount times 0,1 formula typed in the first interest cell&#8221; title_text=&#8221;Amount times 0,1 formula typed in the first interest cell&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> As soon as you press \u2018Enter\u2019, the formula is copied down to the last row.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-table-filled.webp&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 interest column filled to the last table row&#8221; title_text=&#8221;Interest column filled to the last table row&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Use array formula shortcut<\/h3>\n<p>If you don\u2019t want to convert your data to an Excel table, you can use the array shortcut to apply the formula to the entire column. Like in the previous example, I want to multiply each value in the first column by 0.1 (10%).<\/p>\n<p><strong>1.<\/strong> Select the cells to which you want to copy the formula and click on the formula bar.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-select-cells.webp&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 empty interest cells B2:B20 selected&#8221; title_text=&#8221;Empty interest cells B2:B20 selected&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Type the formula and press Ctrl + Shift + Enter. In Excel for Microsoft 365, you can also type the formula in the first cell and press Enter, and the results spill down the column on their own.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-array-formula.webp&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 =A2:A20*0,1 typed in the formula bar&#8221; title_text=&#8221;=A2:A20*0,1 typed in the formula bar&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> The formula is applied, and the results appear in the selected cells.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-array-result.webp&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 array formula in braces with results in every selected cell&#8221; title_text=&#8221;Array formula in braces with results in every selected cell&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Use fill tool<\/h3>\n<p>The fill tool allows you to copy the cell and fill up, down, left, or right. Select the cells &#8211; including the one with the formula &#8211; and go to \u2018Editing\u2019 in the \u2018Home\u2019 tab.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-editing-fill.png&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 total cells selected and the Fill button in the Editing group&#8221; title_text=&#8221;Total cells selected and the Fill button in the Editing group&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Click to see the \u2018Fill\u2019 drop-down menu. In this case, I will select \u2018Down\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-fill-down.png&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 Fill drop-down open with Down highlighted&#8221; title_text=&#8221;Fill drop-down open with Down highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>As you can see, the formula has been copied down, and the references adjusted.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-fill-result.png&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 total column filled with =A2+B2 copied down&#8221; title_text=&#8221;Total column filled with =A2+B2 copied down&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Double-click fill handle<\/h3>\n<p>Select the cell with the formula and double-click the fill handle in the bottom-right corner of the cell to copy it down.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-fill-handle.png&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 fill handle of cell C2 marked with a red box&#8221; title_text=&#8221;Fill handle of cell C2 marked with a red box&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>The formula is automatically copied down to the last row.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-double-click.png&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 total column filled to row 20 after the double-click&#8221; title_text=&#8221;Total column filled to row 20 after the double-click&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Drag fill handle<\/h3>\n<p>Alternatively, you can drag the fill handle to copy the formula.<\/p>\n<p><strong>1.<\/strong> Select the cell with the formula and grab the fill handle.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-drag-handle.png&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 red arrow dragging the fill handle from C2 down to row 20&#8243; title_text=&#8221;Red arrow dragging the fill handle from C2 down to row 20&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Drag it over the cells to which you want to copy in any direction you want.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-drag-result.png&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 totals filled down with the Auto Fill Options button&#8221; title_text=&#8221;Totals filled down with the Auto Fill Options button&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Use shortcut<\/h3>\n<p>Finally, you can use a keyboard shortcut to copy the formula down to the selected cells instantly.<\/p>\n<p><strong>1.<\/strong> Select the cell with the formula and the relevant cells in the column.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-shortcut-select.png&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 cells C2:C20 selected with =A2+B2 in C2&#8243; title_text=&#8221;Cells C2:C20 selected with =A2+B2 in C2&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Press Ctrl + d (Windows) or Cmd + d (Mac). To copy across a row instead of down a column, select the row and use Ctrl + r or Cmd + r.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/copy-formula-down-column-excel-shortcut-result.png&#8221; alt=&#8221;Copy a formula down a column in Excel \u2014 total column filled after the Ctrl + d shortcut&#8221; title_text=&#8221;Total column filled after the Ctrl + d shortcut&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>There are multiple ways to copy formulas in Microsoft Excel, depending on your preference and how the data is structured. Suppose the cells referenced in your formula are spread out over your spreadsheet or contained within multiple ranges with different structures. In that case, it\u2019s especially important to use the appropriate referencing for each cell: absolute, relative, or mixed.<\/p>\n<p>The simplest way to ensure that your formulas are accurately copied to a whole column in a table is to turn the range into an Excel table. If you don\u2019t want to use an Excel table, you know there are multiple methods you can use to copy a formula in any direction you want. These methods include using the array formula shortcut, using the fill tool, dragging or double-clicking the cell\u2019s fill handle, and using a keyboard shortcut to copy the formula down or across the selected cells.<\/p>\n<p>To learn how to lock cells, transfer data, and other Excel topics, check out the guides on:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/how-to-lock-cells-in-excel\/\">How to lock cells in Excel? (cells, sheets &amp; formulas)<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/excel-reference-another-sheet\/\">How to reference another sheet or workbook in Excel?<\/a><\/li>\n<li><a href=\"https:\/\/golayer.io\/blog\/excel\/transfer-data-from-one-excel-worksheet-to-another-automatically\/\" target=\"_blank\" rel=\"noopener\">Transfer data from one Excel worksheet to another automatically<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/compare-two-excel-files\/\">How to compare two Excel files for differences?<\/a><\/li>\n<\/ul>\n<p>Working in Google Sheets instead? See how to <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/fill-down-google-sheets\/\">fill down in Google Sheets<\/a>. To move formula results into another workbook without copying them by hand, you can <a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/transfer-data-in-excel\/\">transfer data from one sheet to another in Excel<\/a> with Sheetgo, an AI-powered data automation platform. For more formulas worth copying, start with these <a href=\"https:\/\/www.sheetgo.com\/blog\/excel-functions\/top-10-excel-functions\/\">top 10 Excel functions<\/a>.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Veja como copiar uma f\u00f3rmula no Excel de 9 maneiras, do Colar Especial e da al\u00e7a de preenchimento at\u00e9 atalhos que preenchem uma coluna inteira.<\/p>","protected":false},"author":2,"featured_media":264382,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[65],"tags":[],"class_list":["post-264354","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-functions"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/264354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=264354"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/264354\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/264382"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=264354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=264354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=264354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}