For instance, what do you do when you need to fill up hundreds of rows? Typing values one by one would take a long while. This article will show you how to autofill rows and columns in Google Sheets.
How to Autofill Rows and Columns With the Same Values
Here’s how to autofill the same values into a row or column in Google Sheets:
Fill in the value you want to replicate into the desired cell. Click on the cell. It would be highlighted in blue. Hover over the small blue cube at the bottom right of the highlighted cell till it turns to a black cross. Click and extend the cross over the number of rows or columns you want to be filled. Google Sheets fills in your values automatically.
How to Autofill Rows and Columns With Consecutive Values
Consecutive values are values that follow each other in order or continuously. Examples of consecutive values are numbers, days of the week, months, times, and dates.
Instead of typing out these values, Google Sheets allows you to automate this and even format the values in your sheets. Here’s how to autofill cells with consecutive values:
Fill two cells with two consecutive values. Click and drag your cursor over the two cells till they are highlighted in blue. Hover over the small blue cube at the bottom left of the highlighted cells till it becomes a black cross. Click and extend the cross over the number of rows or columns you want to be filled. Google Sheets fills in your values automatically.
Make Better Spreadsheets With Google Sheets
There is no doubt that the Google Sheets application comes with many advantages. It provides easy formatting options, automation tools, and add-ons to make your spreadsheets look great.
If you plan to make better spreadsheets, collaborate, and visualize your data, you can check the menu bar for tools, extensions, training, and help.
