To copy a formula down in Google Sheets without dragging, double-click the blue fill handle or select the range and press Ctrl+D (Windows/ChromeOS) or Cmd+D (Mac).
If you’ve ever needed to drag a formula down in Google Sheets without dragging, the answer is built right into the interface. The old method of clicking the fill handle and dragging it manually through hundreds or thousands of rows is tedious and slow. Google Sheets offers built-in alternatives that do the same work instantly. This article covers the two core keyboard-and-click methods—double-click fill and keyboard fill-down—plus a third power-user option that eliminates manual copying altogether.
Dragging a Formula Down in Google Sheets: Alternative Methods That Work
Three reliable routes let you auto-fill formulas without ever touching the drag handle. The table below compares their mechanics and the ideal use case for each, so you can pick the right one for your current sheet.
| Method | How To | Best For |
|---|---|---|
| Double‑Click Fill Handle | Enter your formula in the top cell, then double‑click the small blue square at its bottom‑right corner. | Long, uninterrupted columns of data in an adjacent cell. |
| Keyboard Shortcut (Ctrl+D / Cmd+D) | Select the source cell and the target range below it, then press Ctrl+D (Windows/ChromeOS) or Cmd+D (Mac). | Filling a specific block of cells, especially when the adjacent column has blank rows. |
| ARRAYFORMULA | Wrap your existing formula with =ARRAYFORMULA() so it applies to the whole column automatically. |
Dynamic, expanding datasets where you never want to copy a formula again. |
How Does the Double-Click Fill Handle Work?
The fill handle is the small blue square in the bottom-right corner of a selected cell. When you double-click it, Google Sheets looks at the column directly to the left or right, finds the last row with contiguous data, and copies your formula down to match that row.
To use it, type your formula into the first cell of the column where you want the calculation to live. Hover your cursor over the blue square until it changes to a thin plus sign, then double-click. The formula populates every row in that column as long as the neighboring column has no blank cells.
What stops the fill: The double-click method stops at the first blank row it encounters in the adjacent column. If your data has gaps, the fill stops short of where you need it. In that case, switch to the keyboard shortcut.
What if I Need to Fill a Formula Down a Very Large Column?
For columns that contain hundreds or thousands of rows—or for cases where the adjacent data has gaps—the keyboard shortcut is faster and more reliable than the fill handle. Google Sheets relies on a handy keyboard shortcut to fill down a selected range: Ctrl+D on Windows and ChromeOS, Cmd+D on Mac.
Step‑by‑step for keyboard fill-down:
- Click the cell that contains the formula you want to copy.
- Select the range directly below it. Drag your cursor downward through the cells you want to fill, or use the keyboard to select the range: press Ctrl+Shift+Down (Windows) or Cmd+Shift+Down (Mac) to select all contiguous cells in the column.
- Press Ctrl+D (Windows) or Cmd+D (Mac). The formula fills the entire selected range in one instant step.
Every cell in the selected range displays the correct calculated value, and the formula adjusts its row references as expected.
Using ARRAYFORMULA to Never Drag Again
ARRAYFORMULA is the most advanced option and the one that completely eliminates the need to copy or fill. Instead of entering a formula in one cell and copying it down, you wrap it in =ARRAYFORMULA() and apply it to an entire column at once.
Example: Suppose column A has quantities and column B has prices. Instead of entering =A2*B2 in row 2 and dragging down, you enter this formula in row 1:
=ARRAYFORMULA(IF(A2:A="","",A2:A*B2:B))
This formula checks each row in columns A and B and multiplies the values, leaving blank cells empty. As you add new rows, ARRAYFORMULA applies the calculation automatically without any manual filling.
ARRAYFORMULA changes the mental model of how you structure your sheet. It works best when you want a single formula to govern an entire column, but it may conflict with other manual entries in that column.
Mobile Workflow: Autofill on iPhone and Android
The Google Sheets mobile app for iPhone and Android does not display the traditional fill handle in the same way as the desktop version. To replicate the behavior of dragging a formula down without dragging, use the Autofill action from the cell menu.
How to use Autofill on mobile: Select the cell that contains the formula, tap and hold it until the context menu appears, then choose Autofill. A blue selection box appears; drag the handles of that box downward to cover the rows you want to fill. The formulas populate the selected range.
Limits on mobile: The double-click and keyboard shortcut methods are only available in the web app on a desktop or laptop. If you work primarily on a phone or tablet, the Autofill menu is the primary route.
Why Won’t My Formula Fill Down Correctly?
Even with the right method, formulas can misbehave. The table below covers the most common issues and their solutions so you can troubleshoot in seconds.
| Problem | Likely Cause | Quick Fix |
|---|---|---|
| Double‑click filled the formula too early. | A blank row exists in the column next to your data. | Fill in the blank row, or use the keyboard shortcut method instead. |
| The formula reference broke when filling down. | Relative references (A1) shifted row by row when they shouldn’t have. | Lock the reference with $ signs (e.g., $A$1) before filling. |
| The fill handle isn’t showing up. | The selected cell is part of a merged group. | Unmerge the cells, or select the top‑left cell of the merged range. |
| Ctrl+D or Cmd+D doesn’t do anything. | The range wasn’t selected before pressing the shortcut. | Highlight the source cell and the target cells below it, then press the shortcut again. |
Final Checklist: Filling Formulas Fast Without a Mouse
You no longer need to waste time dragging a fill handle through thousands of rows. Here is the short sequence to memorize for every spreadsheet session.
- Enter your formula in the top cell of the target column.
- Pick your match:
- Continuous data: Double‑click the fill handle.
- Specific or gapped range: Select the range, then press Ctrl+D (Windows) / Cmd+D (Mac).
- Entire column for good: Use
=ARRAYFORMULA().
- Confirm the result: Check that the formula adjusted its references correctly—relative references shift row by row; absolute references with $ signs stay locked.
Master these three methods and you will never manually drag a formula down a column again.
References & Sources
- Sheetgo. “How to Fill Down Google Sheets, Save Time with These Shortcuts.” Documents the Ctrl+D/Cmd+D fill-down keyboard shortcut and relative vs. absolute references.
- YouTube. “How to Copy a Formula Down an Entire Column in Google Sheets.” Demonstrates double-click fill handle and ARRAYFORMULA methods.
- Google Docs Editors Community. “Fill Down for a Large Amount of Rows.” Community guidance on selecting large ranges and applying fill-down.