How To Autofill In Google Sheets Without Dragging

When working with data in Google Sheets, you may often need to copy and paste data from one cell to another. But doing this manually can be time-consuming, especially with large amounts of data. That’s where the Autofill feature comes in handy! But what if you don’t want to use the traditional drag method? Let’s explore how to autofill in Google Sheets without dragging!

Autofill using the Fill Down, Up, Left, or Right command

Google Sheets has an option that allows you to autofill data in cells without dragging the fill handle. The Fill Down, Up, Left, or Right command is very simple to use.

Step 1: Input the Data You Want to Autofill

First, you need to input the data you want to autofill in one cell. For instance, let’s say you want to fill a column with the number 1. You’ll input 1 in the first cell of the column.

Step 2: Select the Range of Cells You Want to Autofill

Next, select the range of cells you want to autofill. Starting with the cell that contains the data you want to copy, drag your cursor to the last cell you want to autofill.

Step 3: Use the Fill Down, Up, Left, or Right Command

Now, go to the “Edit” menu in Google Sheets. From the dropdown menu, select “Fill”, then choose “Down”, “Up”, “Left”, or “Right”, depending on where you want to autofill your data. Once you click the command, the selected cells will be autofilled with the data from the first cell.

Here’s what the code might look like:

    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getSheets()[0];
    var range = sheet.getRange("A1:A10");
    range.autoFill(sheet.getRange("A1:A20"), SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES);

By using this simple command, you can easily autofill cells in Google Sheets without having to drag the fill handle. It’s a great way to save time and make your data management tasks more efficient.


Google Sheets provides users with powerful tools to simplify and automate data entry tasks. The Autofill feature, especially when used with the Fill Down, Up, Left, or Right command, is one such tool. We hope this guide has helped you learn how to use these features effectively. Happy data handling!