How to Apply a Formula to an Entire Column on Google Sheets on Android

This wikiHow teaches you how to replicate a formula in every cell of a column using Google Sheets for Android.

Steps

  1. Image titled Apply a Formula to an Entire Column on Google Sheets on Android Step 1
    1
    Open Google Sheets on your Android. It's the white table on a green background in the app drawer. You may also find it on the home screen.
  2. Image titled Apply a Formula to an Entire Column on Google Sheets on Android Step 2
    2
    Tap the file you wish to edit.
    Advertisement
  3. Image titled Apply a Formula to an Entire Column on Google Sheets on Android Step 3
    3
    Type a formula into the first cell of a column. This the formula that you'll want to apply to the whole column.
    • If you don't want the formula to change relative to each cell, put a “$” before the letter and number of each cell used in the formula. For example, =PRODUCT(A1:C1) would become =PRODUCT($A$1:$C$1).
  4. Image titled Apply a Formula to an Entire Column on Google Sheets on Android Step 4
    4
    Tap
    Android 7 Done
    .     This runs the formula in the current cell.
  5. Image titled Apply a Formula to an Entire Column on Google Sheets on Android Step 5
    5
    Tap and hold the column header. This is the letter at the top of the column in which you entered the formula. This selects the column and displays a row of buttons.
  6. Image titled Apply a Formula to an Entire Column on Google Sheets on Android Step 6
    6
    Tap ⁝. It's the last button in the row.
  7. Image titled Apply a Formula to an Entire Column on Google Sheets on Android Step 7
    7
    Tap AUTO-FILL. This applies the formula to the entire column.
    8. Advertisement

You Might Also Like

Find Your Phone Number on Android
How to
Find Your Phone Number on Android
Remove the Emergency Call Button on Android
How to
Remove the Emergency Call Button on Android
Hide Apps on Android
How to
Hide Apps on Android
Best Tachiyomi Manga ExtensionsHow to Find the 9 Best Manga Extensions for Tachiyomi
Check What Kind of Android Phone You Have
How to
Check What Kind of Android Phone You Have
Connect Android Phone to Computer
How to
Connect Android Phone to Computer
Access the Clipboard on AndroidA Guide To Copying and Pasting with the Android Clipboard
Change Number of Rings on Android
How to
Change Number of Rings on Android
Unlock an Android Tablet4 Ways to Unlock an Android Tablet
Change the Screen Resolution on Your Android
How to
Change the Screen Resolution on Your Android
See if Someone Read Your Text on Android
How to
See if Someone Read Your Text on Android
Unroot Android
How to
Unroot Android
Disable Parental Controls on Android
How to
Disable Parental Controls on Android
Fix Insufficient Storage Available Error in Android6 Ways to Fix "Insufficient Storage Available" on an Android
Advertisement

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 20,136 times.
How helpful is this?
Co-authors: 2
Updated: September 6, 2019
Views: 20,136
Categories: Android
Article SummaryX

1. Open Sheets.
2. Tap the file.
3. Type a formula.
4. Tap the check mark.
5. Tap and hold the column letter.
6. Tap ⁝.
7. Tap AUTO-FILL.

Did this summary help you?
Advertisement