In this tutorial, you will learn how to copy a formula in Google Sheets. How To Copy Formula In Google SheetsOften when working in Google Sheets youll want to enter the same formula in multiple cells. Show You could manually re-type the formula each time it appears, but this would be slow even for a small spreadsheet and could take hours on larger spreadsheets with more complex formulas. Instead of taking the time to retype your formulas, try one of the options below to copy formulas in Google Sheets. Quick Navigation
Copy Formulas Using the MenuStep 1Select the cell containing the formula you want to copy. Open the Edit menu and select the Copy option: Step 2Select the cell you want to copy the formula to. Open the Edit menu and select the Paste option. The formula will appear in the selected cell. Step 3If the cell you copied the formula from had any formatting, the formatting will be copied to the new cell along with the formula. If you do not want to copy the formatting, you can use the Paste Special submenu just below the Paste menu option to select the type of paste you want to use. Step 4To do this, open the Edit menu, hover over the Paste Special submenu to open it, and select Paste Formula Only Step 5This type of pasting formulas does not change the destination cell formatting Copy Formulas Using Keyboard ShortcutsYou may have noticed in the screenshots for the menu option above that the copy and paste menu items had keyboard shortcuts beside them. You can use these keyboard shortcuts more quickly copy and paste formulas:
Copy Formulas Using the Drag HandleA third way to copy formulas in Google Sheets is to use the drag handle to drag the formula to adjacent cells Step 1Select the cell containing the formula you want to copy. A small blue square will appear in the lower right-hand corner of the selected cell. This is the drag handle: Step 2Click and drag the drag handle to select the cells you want to copy the formula to. You can drag across a row or up/down a column. Step 3When you release the mouse, the formula will be copied to all cells that you dragged the selection over. You can repeat this process to cover more cells until youve copied the formula to all necessary cells: Note that you also cannot use Paste Special options here. All formatting from the original cell will be copied to all new cells along with the formula. SummaryExample Spreadsheet: Make a copy of the example spreadsheet In this tutorial, I covered how to copy a formula in Google Sheets. Want more? Check out all the Google Sheets Tutorials. You might also like:How To Keep A Running Total In Google Sheets How To Do Square Root In Google Sheets How To Add Multiple Trendlines In Google Sheets How To Lock A Formula In Google Sheets |