From the course: Google Sheets Essential Training (2021)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Creating a series of numbers, letters, or dates

Creating a series of numbers, letters, or dates - Google Sheets Tutorial

From the course: Google Sheets Essential Training (2021)

Start my 1-month free trial

Creating a series of numbers, letters, or dates

“

- [Instructor] If you're entering a list of ordered numbers, letters, or dates in a single column or row, using quick entry tricks for creating these series will save you time and minimize errors. I'll use the solar panel chart to show you how these quick data entry tips work. You can download this file and follow along, it's titled series in the exercise files chapter three folder. First, I'll show you a quick way to create a column of numbers that increases or decreases by one in each row. Let's say I want to create a list of numbers that increment by one, starting with the number 12, in the solar panel size column. First, I need to enter at least two instances of the series, so I'll type the number 13 in the next cell in the column, then I'll select both columns that contain the series I want to continue. Then I'll hover over the bottom right corner of the bottom cell, where that blue square is, until my cursor turns…

Contents