Which excel feature makes it easy to copy and paste formulas in multiple cells?
|
To copy a formula into multiple adjoining cells in Microsoft Excel, type the formula into a cell, and then press Enter or Return to calculate it. Hover your mouse cursor over the bottom-right corner of the cell so the cursor turns to a crosshair, then drag the crosshair down to copy the formula to other cells in the column. If you'd rather copy the formula to cells in a row, drag the crosshair left or right. To copy a formula to cells that aren't touching the formula cell, click the cell once to select it, and then press Control + C (on a PC) or Command + C (on a Mac) to copy the formula. Now, select the cell or cells you want to copy the formula to, then press Control + V (on a PC) or Command + V (on a Mac) to paste it into the selected cells. Show
Did this summary help you?YesNo Thanks to all authors for creating a page that has been read 504,332 times. Copy and Paste is one of the commonly performed activities while working with Microsoft Excel. We can copy any text, formula, or format in Excel. Here in this article, we will show how to copy the exact formula in Excel with 13 methods using proper illustrations. Table of Contents hide Download Practice Workbook 13 Methods to Copy Exact Formula in Excel 1. Copy Formula Using Double Click 2. Copy Formula in Excel by Dragging 3. Excel Fill Feature to Copy Formula 4. Copy Formula Using Simple Copy-paste 5. Use CTRL Hotkey to Copy Formula to Right and Down Sides 6. Copy Formula Using CTRL+X 7. Copy Formula Using Absolute References 8. Use CTRL+ENTER to Copy Exact Formula in Multiple Cells 9. Copy Exact Formula Using CTRL+' in the Down Cell 10. Use Mouse to Move Exact Formula in Excel 11. Excel Table to Copy Exact Formula 12. Use Find and Replace Tool to Copy Exact Excel Formula 13. Using Notepad to Copy Paste Formulas in Excel Conclusion Related Articles Download Practice WorkbookDownload this practice workbook to exercise while you are reading this article. Copy Exact Formula.xlsx 13 Methods to Copy Exact Formula in ExcelWe can copy any formula with the relative cell references, or fixed cell references. We will discuss both cases through the methods below.  The above dataset will be used for this tutorial. 1. Copy Formula Using Double ClickJust double-click the mouse to copy the formula from the above cell. Step 1:
Step 2:
Step 3:
Now, look at the dataset. The formula is copied to the rest of the cells. It will copy the formula through the column before getting any empty cell reference. Related Content: How to Copy Formula in Excel (6 Quick Methods) 2. Copy Formula in Excel by DraggingWe can copy any formula by dragging. Dragging has the advantage of copying any formula in any direction left, right, up, or down. We have a formula on Cell F5. We will copy this formula into 4 directions. Step 1:
Now, we can see that the formula is copied towards the adjacent right cell. Step 2:
We can see that formula is copied downwards. Similarly, we can copy the formula towards the left or upper side. Read More: How to Copy Formula in Excel without Dragging (10 Ways) 3. Excel Fill Feature to Copy FormulaWe can copy the formula using the Excel Fill tool. We have a formula on Cell F5. Using the Fill tool, we will copy the formula of Cell F5 in four different directions. Step 1:
Now, look at the dataset. The formula is copied to the right side. Step 2:
Read More: Copy Formula in Excel by Changing Only One Cell Reference 4. Copy Formula Using Simple Copy-pasteThe simplest method to copy the formula is just to press CTRL+C. In this section, we will use this method. Step 1:
Step 2:
Look at the dataset. The mentioned formula is copied to the desired cell. Here, the formula is copied exactly like the original formula. Cell references are not changed here. If we copy the cell by editing the cell, the cell references will change. Read More: How to Copy Formula and Paste as Text in Excel (2 Ways) 5. Use CTRL Hotkey to Copy Formula to Right and Down SidesCTRL button is known as the modifier key. We can use this option to copy the formula in two directions: Right and Down sideS. The formula is copied only in the adjacent cells. Step 1:
Notice the dataset. The formula is copied to the cell below. Step 2:
Now, the formula is copied to the right side cell. We can not copy the formula to the adjacent up and left side using this modifier tool. Related Content: How to Copy a Formula Down the Column in Excel(7 Methods) 6. Copy Formula Using CTRL+XWe can use the CTRL+X option to copy a formula. By applying this method, we can copy the exact formula, cell references will remain unchanged. Step 1:
The formula is copied now. We will paste the formula on Cell F8. Step 2:
Our formula is copied exactly, no changes happened here. Read More: Shortcut to Copy Formula Down in Excel (7 Ways) 7. Copy Formula Using Absolute ReferencesWe will use Absolute cell reference in the formula. And copy that formula using the ribbon option. Because of absolute cell references, the formula will remain unchanged. Step 1:
The formula is copied now. Step 2:
Look at the dataset now. The formula is copied exactly. Read More: Excel VBA to Copy Formula with Relative Reference (A Detailed Analysis) 8. Use CTRL+ENTER to Copy Exact Formula in Multiple CellsWe can copy the same formula in multiple cells at the same time by pressing CTRL+ENTER. Step 1:
Step 2:
Step 3:
All the selected cells are filled with the copied formula. Read More: How to Copy a Formula Across Multiple Rows in Excel (5 Ways) 9. Copy Exact Formula Using CTRL+' in the Down CellWe copy the exact formula and make the cell editable using Step 1:
Look at the dataset. Cell F6 now contains the formula from the previous cell and is in an editable mood. Step 2:
Here, the result is shown after the implementation of the formula. 10. Use Mouse to Move Exact Formula in ExcelWe can simply move the formula using the mouse. Step 1:
Step 2:
Now, see that formula is copied exactly with no changes. 11. Excel Table to Copy Exact FormulaExcel Table is a useful tool. We can copy formulas using this tool also. Step 1:
Step 2:
Step 3:
The rest of the cells of the Total column are filled with data. So, the formula is copied successfully. 12. Use Find and Replace Tool to Copy Exact Excel FormulaThe Find & Replace method can easily copy Excel formulas exactly. In this section, we have a formula on Cell F5 and we will copy this formula. Step 1:
A pop-up is showing, indicating the number of replacements. Step 2:
Step 3:
Step 4:
Notice the dataset now. Related Content: 3 Quick Ways to Copy Down Excel Formula without Incrementing 13. Using Notepad to Copy Paste Formulas in ExcelUsing the notepad we will copy the exact formula in Excel. We have a formula on Cell F5. We will copy that formula into another cell. Step 1:
Now, any formula that exists in the sheet will show. Step 2:
Step 3:
Step 4:
Step 5:
Step 6:
Step 7:
Look at the dataset now. We copied the exact formula in the new cell. ConclusionIn this article, we described how to copy exact formulas in Excel. We added 13 methods to do this. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box. Which Excel feature makes it easy to copy and paste formulas in multiple cells fast copy?Use the fill handle in Excel to quickly copy a formula to other cells. 1. For example, select cell A3 below, click on the lower right corner of cell A3 (the fill handle) and drag it across to cell F3. Result.
Which feature allows to quickly copy formulas in Excel?You can quickly copy formulas into adjacent cells by using the fill handle. When you drag the handle to other cells, Excel will show different results for each cell.
What is the shortcut to copy and paste multiple cells in Excel?Copy the completed cell (CTRL +C), then select the cells (SHIFT + Arrow Keys) where you want to repeat the formula and do a Paste (CTRL + V or Enter), or Paste Special (CTRL + ALT + V) if you only want to paste some attributes of the copied cell.
|
