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. Open Google Sheets and tap a file.
    This opens the file for editing.[1]
    2. Advertisement
2

Tap the first cell in the series.

PDF download Download Article
  1. 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.[2]
3

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

PDF download Download Article
  1. You'll want to select at least two cells that are next to each other.
    The entire area is now highlighted.[3]
    2. Advertisement
4

Tap the highlighted area.

PDF download Download Article
  1. Tap the area you've highlighted.
    A pop-up will appear.[4]
5

Tap "Autofill."

PDF download Download Article
  1. 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.[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
Name
Please provide your name and last initial
Submit
Thanks for submitting a tip for review!

You Might Also Like

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
Add the Same Value to Multiple Cells in Excel
How to
Copy the Same Text to Multiple Cells in Excel: Desktop & Mobile
Fill Blank Cells in Excel
How to
Fill Blank Cells in Excel
Copy Formulas in Excel
How to
Copy Formulas in Excel
Edit Google Sheets on Mobile
How to
Edit Google Sheets on Mobile
Link Sheets in Excel
How to
Link Sheets in Excel
Highlight a Whole Column in Google Sheets3 Simple Ways to Highlight a Column in Google Sheets
Generate a Number Series in MS Excel4 Step-by-Step Methods to Generate a Number Series in Excel
Add Rows in Excel with a Formula
How to
Add Rows in Excel with a Formula
Use Google Spreadsheets
How to
Use Google Sheets: The Ultimate Guide for Getting Started
Delete Rows on Google Sheets on Android5 Simple Steps to Delete Rows on Google Sheets on Android
Edit Data in Microsoft Excel3 Simple Ways to Edit Data in MS Excel
Add Autonumber in Excel2 Easy Ways to Add Auto-Numbering in Microsoft Excel
Search Within a Google Docs Spreadsheet
How to
Search Within a Google Docs Spreadsheet
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

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 100,064 times.
How helpful is this?
Co-authors: 3
Updated: November 13, 2024
Views: 100,064
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?

In other languages
Thanks to all authors for creating a page that has been read 100,064 times.

Is this article up to date?

Advertisement