How to Copy Formulas on Google Sheets on PC or Mac

This wikiHow teaches you how to copy and paste formulas in Google Sheets for PC and Mac.

Steps

  1. Image titled Copy Formulas on Google Sheets on PC or Mac Step 1
    1
    Go to https://sheets.google.com in a web browser. If you are logged in with your Google account, this will bring up a list of all the Google Sheet documents associated with your account.
  2. Image titled Copy Formulas on Google Sheets on PC or Mac Step 2
    2
    Open a Google sheet from your list.
    Advertisement
  3. Image titled Copy Formulas on Google Sheets on PC or Mac Step 3
    3
    Click the cell with the formula you want to copy.
  4. Image titled Copy Formulas on Google Sheets on PC or Mac Step 4
    4
    Click Edit at the top.
  5. Image titled Copy Formulas on Google Sheets on PC or Mac Step 5
    5
    Click Copy from the edit menu.
    • You can also right-click a cell and select Copy.
  6. Image titled Copy Formulas on Google Sheets on PC or Mac Step 6
    6
    Click to select the cell you want to paste the formula in.
  7. Image titled Copy Formulas on Google Sheets on PC or Mac Step 7
    7
    Click Edit.
  8. Image titled Copy Formulas on Google Sheets on PC or Mac Step 8
    8
    Select Paste Special.
    • You can also right-click the cell you want to paste in and select Paste Special.
  9. Image titled Copy Formulas on Google Sheets on PC or Mac Step 9
    9
    Click Paste Formula Only. This will paste the formula without any other additional data or conditional formatting the cell may contain.
    10. Advertisement

You Might Also Like

Alphabetize in Google DocsHow to Alphabetize in Google Docs: 4 Simple Methods
Save a Google Doc
How to
Save a Google Doc
Make a Brochure Using Google DocsHow to Make a Brochure Using Google Docs: Quick Guide
Flip an Image in Google Docs9 Easy Steps to Flip an Image in Google Docs
Make a Signup Sheet on Google Docs3 Simple Ways to Make a Signup Form on Google Docs
Share Google Docs
How to
Share Google Docs
Download Google Docs4 Easy Ways to Download and Save Google Docs
Make a Google Doc Public
How to
Make a Google Doc Public
Use Google SpreadsheetsHow to Use Google Sheets: The Ultimate Guide for Getting Started
View Google Form Responses on iPhone or iPadHow to View Google Form Responses on iPhone or iPad
Check Google Doc HistoryHow to Check a Google Doc's History (and Restore Previous Versions)
Convert a Google Doc to a PDF on iPhone or iPad
How to
Convert a Google Doc to a PDF on iPhone or iPad
Open Google DocsEasily Open Google Docs in a Browser, the App, or MS Word
Create a Copy of a Google Form
How to
Create a Copy of a Google Form
Advertisement

About This Article

Travis Boylls
Written by:
Travis Boylls
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Travis Boylls. Travis Boylls is a Technology Writer and Editor for wikiHow. Travis has experience writing technology-related articles, providing software customer service, and in graphic design. He specializes in Windows, macOS, Android, iOS, and Linux platforms. He studied graphic design at Pikes Peak Community College. This article has been viewed 61,857 times.
How helpful is this?
Co-authors: 3
Updated: August 7, 2018
Views: 61,857
Categories: Google Docs | Spreadsheets
Advertisement