How to Fill a Series on Google Sheets on Android

PDF download Download Article
PDF download Download Article

This wikiHow teaches you how to copy a value or formula to a series of cells using Google Sheets for Android.

Quick Guide: Dragging Formulas on the Google Sheets App

  1. Tap the cell with the formula you want to drag to other cells.
  2. Use your finger to drag the blue border around all the cells you want to select.
  3. Tap on the cells you just highlighted.
  4. Select Autofill from the contextual menu.
1

Open a Google Sheets file.

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/90\/Fill-a-Series-on-Google-Sheets-on-Android-Step-2.jpg\/v4-460px-Fill-a-Series-on-Google-Sheets-on-Android-Step-2.jpg","bigUrl":"\/images\/thumb\/9\/90\/Fill-a-Series-on-Google-Sheets-on-Android-Step-2.jpg\/aid9585569-v4-728px-Fill-a-Series-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>"}
    This opens the file for editing. [1]
    2. Advertisement
2

Tap the first cell in the series.

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/83\/Fill-a-Series-on-Google-Sheets-on-Android-Step-3.jpg\/v4-460px-Fill-a-Series-on-Google-Sheets-on-Android-Step-3.jpg","bigUrl":"\/images\/thumb\/8\/83\/Fill-a-Series-on-Google-Sheets-on-Android-Step-3.jpg\/aid9585569-v4-728px-Fill-a-Series-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>"}
    The cell is now surrounded by a blue border. [2]
3

Tap and drag the blue border to the end of the series.

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1d\/Fill-a-Series-on-Google-Sheets-on-Android-Step-4.jpg\/v4-460px-Fill-a-Series-on-Google-Sheets-on-Android-Step-4.jpg","bigUrl":"\/images\/thumb\/1\/1d\/Fill-a-Series-on-Google-Sheets-on-Android-Step-4.jpg\/aid9585569-v4-728px-Fill-a-Series-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>"}
    The entire area is now highlighted. [3]
    2. Advertisement
4

Tap the highlighted area.

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/21\/Fill-a-Series-on-Google-Sheets-on-Android-Step-5.jpg\/v4-460px-Fill-a-Series-on-Google-Sheets-on-Android-Step-5.jpg","bigUrl":"\/images\/thumb\/2\/21\/Fill-a-Series-on-Google-Sheets-on-Android-Step-5.jpg\/aid9585569-v4-728px-Fill-a-Series-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>"}
    A pop-up will appear. [4]
5

Tap "Autofill."

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/df\/Fill-a-Series-on-Google-Sheets-on-Android-Step-7.jpg\/v4-460px-Fill-a-Series-on-Google-Sheets-on-Android-Step-7.jpg","bigUrl":"\/images\/thumb\/d\/df\/Fill-a-Series-on-Google-Sheets-on-Android-Step-7.jpg\/aid9585569-v4-728px-Fill-a-Series-on-Google-Sheets-on-Android-Step-7.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 first cell’s value is now applied to every cell in the series. [5]
    • If the value of the first cell contains dates or numbers, the other selected cells will fill with a series that continues the pattern.
    2. 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
      Hide Apps on Android
      Download APKs from Google Play: A Step-by-Step Guide
      How to Set up and Use an IR Blaster on Android
      How to
      Know Chat ID on Telegram on Android
      How to Check What Apps You Have Installed on Android
      How to
      Install APK Files on Android
      A Complete Guide to Lucky Patcher for Android
      How to
      Import Contacts from Excel to an Android Phone
      How To View Who Is Connected to Your Hotspot on Android
      Downloading and Installing WhatsApp to Your Android Device
      How to
      Get in App Purchases for Free (Android)
      How to
      Leave a Group Text on Android
      Saving Photos on Telegram on Android + Fixes
      How to Download Android Apps: The Complete Beginner's Guide
      Advertisement

      References

      1. ↑ https://support.google.com/docs/answer/49114#zippy=%2Cview-a-file
      2. ↑ https://edu.gcfglobal.org/en/googlespreadsheets/getting-started-with-google-sheets/1/
      3. ↑ https://support.google.com/docs/answer/75509?hl=en&co=GENIE.Platform%3DAndroid&oco=1
      4. ↑ https://support.google.com/docs/answer/75509?hl=en&co=GENIE.Platform%3DAndroid&oco=1
      5. ↑ https://support.google.com/docs/answer/75509?hl=en&co=GENIE.Platform%3DAndroid

      About This Article

      Article Summary X

      1. Open Sheets .
      2. Tap a file.
      3. Tap the first cell.
      4. Drag the border to the end of the series.
      5. Tap and hold the selected area.
      6. Tap ⁝ .
      7. Tap AUTOFILL .

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 82,886 times.

      Is this article up to date?

      Advertisement