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.

1

Open a Google Sheets file.

  1. Image titled Fill a Series on Google Sheets on Android Step 2
    Open Google Sheets and tap a file. This opens the file for editing.
    2. Advertisement
2

Tap the first cell in the series.

  1. Image titled Fill a Series on Google Sheets on Android Step 3
    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.
3

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

  1. Image titled Fill a Series on Google Sheets on Android Step 4
    You'll want to select at least two cells that are next to each other. The entire area is now highlighted.
    2. Advertisement
4

Tap the highlighted area.

  1. Image titled Fill a Series on Google Sheets on Android Step 5
    Tap the area you've highlighted. A pop-up will appear.
5

Tap "Autofill."

  1. Image titled Fill a Series on Google Sheets on Android Step 7
    If you don't see Autofill, tap the three horizontal dots first—you'll see it then. The first cell’s value is now applied to every cell in the series.[1]
    • 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

You Might Also Like

Hide Apps on Android
How to
Hide Apps on Android
Download an APK File from the Google Play Store
How to
Download an APK File from the Google Play Store
Use an Android IR Blaster8 Quick & Easy Steps to Using an IR Blaster on an Android
Disable Voicemail on Android
How to
Disable Voicemail on Android
Hide the Notification Bar on Android
How to
Hide the Notification Bar on Android
Change Tip on DoordashTwo Ways to Change Your Tip on DoorDash
Know Chat ID on Telegram on Android
How to
Know Chat ID on Telegram on Android
Get in App Purchases for Free (Android)
How to
Get in App Purchases for Free (Android)
Import Contacts from Excel to an Android Phone
How to
Import Contacts from Excel to an Android Phone
Delete the Call History on Android
How to
Delete the Call History on Android
Save Photos on Telegram on Android
How to
Save Photos on Telegram on Android
Unsubscribe from the BetterMe App
How to
Unsubscribe from the BetterMe App
Advertisement

References

  1. ↑ https://support.google.com/docs/answer/75509?hl=en&co=GENIE.Platform%3DAndroid

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, 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 43,485 times.
How helpful is this?
Co-authors: 3
Updated: June 6, 2022
Views: 43,485
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?
Advertisement