How to Copy Formulas on Google Sheets on Android

PDF download Download Article
PDF download Download Article

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

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9c\/Copy-Formulas-on-Google-Sheets-on-Android-Step-1.jpg\/v4-460px-Copy-Formulas-on-Google-Sheets-on-Android-Step-1.jpg","bigUrl":"\/images\/thumb\/9\/9c\/Copy-Formulas-on-Google-Sheets-on-Android-Step-1.jpg\/aid9554880-v4-728px-Copy-Formulas-on-Google-Sheets-on-Android-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b4\/Copy-Formulas-on-Google-Sheets-on-Android-Step-2.jpg\/v4-460px-Copy-Formulas-on-Google-Sheets-on-Android-Step-2.jpg","bigUrl":"\/images\/thumb\/b\/b4\/Copy-Formulas-on-Google-Sheets-on-Android-Step-2.jpg\/aid9554880-v4-728px-Copy-Formulas-on-Google-Sheets-on-Android-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a7\/Copy-Formulas-on-Google-Sheets-on-Android-Step-3.jpg\/v4-460px-Copy-Formulas-on-Google-Sheets-on-Android-Step-3.jpg","bigUrl":"\/images\/thumb\/a\/a7\/Copy-Formulas-on-Google-Sheets-on-Android-Step-3.jpg\/aid9554880-v4-728px-Copy-Formulas-on-Google-Sheets-on-Android-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    A row of options will appear.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cb\/Copy-Formulas-on-Google-Sheets-on-Android-Step-4.jpg\/v4-460px-Copy-Formulas-on-Google-Sheets-on-Android-Step-4.jpg","bigUrl":"\/images\/thumb\/c\/cb\/Copy-Formulas-on-Google-Sheets-on-Android-Step-4.jpg\/aid9554880-v4-728px-Copy-Formulas-on-Google-Sheets-on-Android-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/df\/Copy-Formulas-on-Google-Sheets-on-Android-Step-5.jpg\/v4-460px-Copy-Formulas-on-Google-Sheets-on-Android-Step-5.jpg","bigUrl":"\/images\/thumb\/d\/df\/Copy-Formulas-on-Google-Sheets-on-Android-Step-5.jpg\/aid9554880-v4-728px-Copy-Formulas-on-Google-Sheets-on-Android-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This is the cell in which you want to paste the copied formula.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/97\/Copy-Formulas-on-Google-Sheets-on-Android-Step-6.jpg\/v4-460px-Copy-Formulas-on-Google-Sheets-on-Android-Step-6.jpg","bigUrl":"\/images\/thumb\/9\/97\/Copy-Formulas-on-Google-Sheets-on-Android-Step-6.jpg\/aid9554880-v4-728px-Copy-Formulas-on-Google-Sheets-on-Android-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The formula will now run in the selected cell.
    7. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Sign Out of Your Google Account on All Devices at Once
      How to Delete Google Photos without Deleting Them on Your Phone
      How to Disable Google Safe Search
      How to Sign Up for a New Google Voice Phone Number
      2 Simple Ways to Unsync Google Photos
      How to Restore Google Authenticator if You Lost or Reset Your Phone
      How to Use Google Translate: Complete Beginner's Guide
      2 Easy Ways to Permanently Delete (or, Hide) Your YouTube Channel
      How to
      Fix the "Google Play Store Has Stopped" Error
      How to Use Dark Mode in Google Docs: Easy Steps for Desktop & Mobile
      Reverse Image Search in Google Lens: Android, iPhone, & Desktop
      How to Step Seeing Google Ads on PC or Mobile Devices
      How to Make a Free Website with Google Sites: Step-by-Step Guide
      Easy Ways to Find Backed Up Photos on Google: 3 Methods
      Advertisement

      About This Article

      Article Summary X

      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?
      In other languages
      Thanks to all authors for creating a page that has been read 37,649 times.

      Is this article up to date?

      Advertisement