How to Copy Formulas on Google Sheets on Android

This wikiHow teaches you how to copy a formula to another cell in Google Sheets for Android.

Steps

  1. Image titled Copy Formulas on Google Sheets on Android Step 1
    1
    Open Google Sheets. It's the green icon with a white table/spreadsheet inside. You'll usually find it on the home screen or in the app drawer.
  2. Image titled Copy Formulas on Google Sheets on Android Step 2
    2
    Tap the file you wish to edit.
    Advertisement
  3. Image titled Copy Formulas on Google Sheets on Android Step 3
    3
    Tap and hold the cell containing the formula. A row of options will appear.
  4. Image titled Copy Formulas on Google Sheets on Android Step 4
    4
    Tap Copy.
  5. Image titled Copy Formulas on Google Sheets on Android Step 5
    5
    Tap and hold the destination cell. This is the cell in which you want to paste the copied formula.
  6. Image titled Copy Formulas on Google Sheets on Android Step 6
    6
    Tap Paste. The formula will now run in the selected cell.
    Advertisement

You Might Also Like

Sign Out of Your Google Account on All Devices at Once
How to
Sign Out of Your Google Account on All Devices at Once
Fix the "Google Play Store Has Stopped" Error
How to
Fix the "Google Play Store Has Stopped" Error
Turn Off Google Safesearch
How to
Turn Off Google Safesearch
Write a Review on Google
How to
Write a Review on Google
Search by Image on Google
How to
Search by Image on Google
Buy a Google Play Gift Card Online on Android
How to
Buy a Google Play Gift Card Online on Android
Access Google Assistant
How to
Access Google Assistant
Make a Google Account Without Gmail
How to
Make a Google Account Without Gmail
Restore Google Authenticator
How to
Restore Google Authenticator
Get a Google Voice Phone Number
How to
Get a Google Voice Phone Number
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
How to
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
Create a Google Profile
How to
Create a Google Profile
Sort by Number on Google Sheets on PC or Mac
How to
Sort by Number on Google Sheets on PC or Mac
Use Google Translate
How to
Use Google Translate
Advertisement

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 22,865 times.
How helpful is this?
Co-authors: 2
Updated: September 6, 2019
Views: 22,865
Categories: Google Applications
Article SummaryX

1. Open Sheets.
2. Tap a file.
3. Tap and hold the cell containing the formula.
4. Tap Copy.
5. Tap and hold the destination cell.
6. Tap Paste.

Did this summary help you?
Advertisement