How to insert data using the fill handle the feature in Google Sheets

Published June 12, 2022

Using the "fill handle" technique, you can copy the contents of a single cell in a spreadsheet to numerous cells within the same column or row. The method allows you to duplicate cell contents quickly without having to copy and paste data in each cell. 

Let’s go through the simple steps involved in inserting data using the fill handle feature in Google sheets.

Steps to insert data using the fill handle the feature in Google Sheets

You can easily insert data using the fill handle in Google Sheets. Simply follow these simple steps:

Step 1: Open a new or an existing Google Sheet spreadsheet

 

How to insert data using the fill handle the feature in Google Sheets


 

Step 2: Fill in one cell with data. This is the data that will be copied to the other cells in the row or column.

How to insert data using the fill handle the feature in Google Sheets-2

 

Step 3: Now, click on the cell. A small square known as a "fill handle" will appear in the bottom-right corner of the cell. 

Click on the fill handle and drag over the cells either in a row or a column.

To duplicate data in a row, drag the fill handle across. In the cells of a row where data will be entered, a dotted black line will appear.

How to insert data using the fill handle the feature in Google Sheets-3

 

Upon releasing the mouse button, the copied data will be filled in all selected cells across the row.

How to insert data using the fill handle the feature in Google Sheets-4

 

To duplicate data in a column, drag the fill handle downwards. Where the data will be duplicated, a dotted black line will appear down the column.

How to insert data using the fill handle the feature in Google Sheets-5

 

Upon releasing the mouse button, the copied data will be filled in all selected cells in a column.

How to insert data using the fill handle the feature in Google Sheets-6

 

 

Conclusion

Finally, we have learned how to duplicate cell content across different cells in a row as well as to other cells down the spreadsheet column.

 

Jeywords: Google Docs, Google Sheet, How to insert data using the fill handle the feature in Google Sheets

Related Google Sheet Question and Answers

How do i create new google sheet

How to delete a sheet in google sheet

How to duplicate google sheet

How to modify rows width columns and cells in google sheet

How to copy and paste cells in google sheet

How to drag and drop cells in google sheet

How to insert data using the fill handle the feature google sheet

How to insert,move and delete rows and columns google sheet

How to select cells in google sheet

How to freeze rows and columns google sheet

How to wrap text and merge cells google sheet

How to change the font size in google sheet

How to change the font in google sheet

How to change text color in google sheet

How to make text bold in google sheet

How to add cell border in google sheet

How to change the cell background color google sheet

How do i align text in google sheet

How to create a complex formula using the orderof operations google sheet

How to create and copy formulas using relative references google sheet

How to use absolute references to create a copy and paste formula google sheet

create formulas using functions in google sheets

How to sort and filter data in google sheets

How to insert image in google sheets

How to rotate text in google sheets

How to enable spell checker in google sheets

How to enable auto complete in google sheets

How to download google sheets

Article Contributed By :
https://www.rrtutors.com/site_assets/profile/assets/img/avataaars.svg

70 Views