This article was written by 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 7,081 times.
This wikiHow teaches you how to fill a series of cells with a value or formula in Google Sheets.
Steps
-
1Go to https://sheets.google.com in a web browser. If you’re not already signed in to your Google account, sign in now.
-
2Click the file you want to edit.Advertisement
-
3Select the cell(s) you want to make into a series. Click one cell to select it, or click and drag to select multiple cells. A blue border will appear around the selected area.
-
4Hover the mouse over the blue square. It’s at the bottom-right corner of the selected cell(s). The cursor will turn into a plus (+) sign.
-
5Click and drag the + down or across the range you want to fill. The value or formula in the selected cell(s) is now repeated in the series.Advertisement
![Fix the "Google Play Store Has Stopped" Error](./images/3828235695--crop-342-184-245px-Fix-the-"Google-Play-Store-Has-Stopped"-Error-Step-36.webp)
About This Article
1. Sign in to https://sheets.google.com.
2. Click a file.
3. Select the cells you want to make into a series.
4. Hover the mouse over the blue square.
5. Click and drag the + across the range to fill.
![Fix the "Google Play Store Has Stopped" Error](./images/3791666599--crop-127-140-127px-Fix-the-"Google-Play-Store-Has-Stopped"-Error-Step-36.webp)
