This article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. 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.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 26,247 times.
This How.com.vn teaches you how to replicate a formula in every cell of a column using Google Sheets for Android.
Steps
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.
Tap the file you wish to edit.
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).
Tap. This runs the formula in the current cell.
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.
Tap ⁝. It's the last button in the row.
Tap AUTO-FILL. This applies the formula to the entire column.Advertisement
Expert Q&A
About this article
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.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
