How to Fill a Series on Google Sheets on Android

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

Steps

  1. Image titled Fill a Series on Google Sheets on Android Step 1
    1
    Open Google Sheets on your Android. It’s the green icon with a white table outline. You’ll usually find it in the app drawer.
  2. Image titled Fill a Series on Google Sheets on Android Step 2
    2
    Tap the file you want to edit.
  3. Image titled Fill a Series on Google Sheets on Android Step 3
    3
    Tap the first cell in the series. This is the cell containing the value or formula you want to appear in the rest of the series. The cell is now surrounded by a blue border.
  4. Image titled Fill a Series on Google Sheets on Android Step 4
    4
    Tap and drag the blue border to the end of the series. The entire area is now highlighted.
  5. Image titled Fill a Series on Google Sheets on Android Step 5
    5
    Tap and hold the highlighted area. A pop-up will appear.
  6. Image titled Fill a Series on Google Sheets on Android Step 6
    6
    Tap ⁝. It’s at the end of the pop-up.
  7. Image titled Fill a Series on Google Sheets on Android Step 7
    7
    Scroll down the menu and tap AUTOFILL. The first cell’s value is now applied to every cell in the series.

You Might Also Like

Download an APK File from the Google Play Store
How to
Download an APK File from the Google Play Store
Know Chat ID on Telegram on Android
How to
Know Chat ID on Telegram on Android
Disable Voicemail on Android
How to
Disable Voicemail on Android
Import Contacts from Excel to an Android Phone
How to
Import Contacts from Excel to an Android Phone
Save Photos on Telegram on Android
How to
Save Photos on Telegram on Android
Hide Apps on Android
How to
Hide Apps on Android
Hide the Notification Bar on Android
How to
Hide the Notification Bar on Android
Use an Android IR Blaster
How to
Use an Android IR Blaster
Get in App Purchases for Free (Android)
How to
Get in App Purchases for Free (Android)
Use Your Phone As a Mic
How to
Use Your Phone As a Mic
Use Lucky Patcher on Android
How to
Use Lucky Patcher on Android
View Who Is Connected to Your Hotspot on Android
How to
View Who Is Connected to Your Hotspot on Android

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 25,163 times.
How helpful is this?
Co-authors: 2
Updated: May 15, 2018
Views: 25,163
Categories: Android Applications
Article SummaryX

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?