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

1
How to

Apply a Formula to an Entire Column on Google Sheets on PC or Mac
2
How to

Copy the Same Text to Multiple Cells in Excel: Desktop & Mobile
3
How to

Fill Blank Cells in Excel
4
How to

Copy Formulas in Excel
5
How to

Edit Google Sheets on Mobile
6
How to

Link Sheets in Excel
Expert
7

3 Simple Ways to Highlight a Column in Google Sheets
8

4 Step-by-Step Methods to Generate a Number Series in Excel
9
How to

Add Rows in Excel with a Formula
10
How to

Use Google Sheets: The Ultimate Guide for Getting Started
11

5 Simple Steps to Delete Rows on Google Sheets on Android
12

3 Simple Ways to Edit Data in MS Excel
13

2 Easy Ways to Add Auto-Numbering in Microsoft Excel
14
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 99,855 times.
How helpful is this?
Co-authors: 3
Updated: November 13, 2024
Views: 99,855
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 99,855 times.

Is this article up to date?

Advertisement