How to Copy Formulas to Google Sheets Using a PC or Mac

Table of contents:

How to Copy Formulas to Google Sheets Using a PC or Mac
How to Copy Formulas to Google Sheets Using a PC or Mac
Anonim

This wikiHow teaches you how to copy and paste formulas into Google Sheets using a PC or Mac.

Steps

Copy Formulas on Google Sheets on PC or Mac Step 1
Copy Formulas on Google Sheets on PC or Mac Step 1

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

Copy Formulas on Google Sheets on PC or Mac Step 2
Copy Formulas on Google Sheets on PC or Mac Step 2

Step 2. Open one of the Google Sheets documents in the list that appeared

  • You can also click on the icon

    Android_Google_New
    Android_Google_New

    to create a new document from scratch.

Copy Formulas on Google Sheets on PC or Mac Step 3
Copy Formulas on Google Sheets on PC or Mac Step 3

Step 3. Click on the cell that contains the formula to copy

Copy Formulas on Google Sheets on PC or Mac Step 4
Copy Formulas on Google Sheets on PC or Mac Step 4

Step 4. Click the Edit menu displayed at the top of the page

Copy Formulas on Google Sheets on PC or Mac Step 5
Copy Formulas on Google Sheets on PC or Mac Step 5

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

Copy Formulas on Google Sheets on PC or Mac Step 6
Copy Formulas on Google Sheets on PC or Mac Step 6

Step 6. Click on the cell where you want to paste the formula to select it

Copy Formulas on Google Sheets on PC or Mac Step 7
Copy Formulas on Google Sheets on PC or Mac Step 7

Step 7. Click on the Edit menu

Copy Formulas on Google Sheets on PC or Mac Step 8
Copy Formulas on Google Sheets on PC or Mac Step 8

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

Copy Formulas on Google Sheets on PC or Mac Step 9
Copy Formulas on Google Sheets on PC or Mac Step 9

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.

Recommended: