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
 |
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.
 |
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.
 |
Upon releasing the mouse button, the copied data will be filled in all selected cells across the row.
 |
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.
 |
Upon releasing the mouse button, the copied data will be filled in all selected cells in a column.
 |
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 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
|
Article Contributed By :
|
|
|
|
|
153 Views |
|