This wikiHow teaches you how to copy and paste formulas into Google Sheets using a PC or Mac.
Steps
Step 1. Visit the website https://sheets.google.com using your computer's internet browser
If you are already logged in with your Google account, a list of all documents created with Google Sheets and associated with your profile will be displayed.
If you haven't logged in with your Google account yet, do so now by following these instructions
Step 2. Open one of the Google Sheets documents in the list that appeared
-
You can also click on the icon
to create a new document from scratch.
Step 3. Click on the cell that contains the formula to copy
Step 4. Click the Edit menu displayed at the top of the page
Step 5. Click on the Copy item
It is one of the options listed in the "Edit" menu.
Alternatively, select the cell in question with the right mouse button, then select the Copy item from the context menu that will appear
Step 6. Click on the cell where you want to paste the formula to select it
Step 7. Click on the Edit menu
Step 8. Select the Paste Special option
Alternatively, select the cell in question with the right mouse button, then select Paste Special from the context menu that will appear
Step 9. Click on the Paste Formula Only option
This will paste into the selected cell only the formula you copied, without any additional data or any information related to conditional formatting.
Advice
- You can copy and paste formulas using hotkey combinations to boost your productivity. Select the desired cell, press the Ctrl + C key combination to copy the data, then press the Ctrl + V key combination to paste it wherever you want.
- You can also apply a formula on multiple cells by simply using the mouse. Read this article to find out how.
- When you copy and paste a formula into a new cell, the references to the data in the other cells will automatically update based on the new location. For example if the formula you copied was = A1 + A2, stored in the cell A3, gluing it into the cell B3 it would automatically take the following form = B1 + B2 (based on the new cell it was entered in). If you want to copy a formula exactly as it appears, you must use absolute references to the cells it contains by prefixing the relative address with the symbol " $". Using the previous example, the formula to insert into the cell A3 it should have the following form = $ A $ 1 + $ A $ 2. In this case, if you copy it to other cells, the references to the data would remain unchanged.