This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
The wikiHow Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 11,542 times.
This wikiHow teaches you how to quickly copy an Excel formula to other cells by dragging it across the range.
Steps
-
1Double-click your spreadsheet to open it in Excel. Or, if you’re creating a new spreadsheet, go ahead and enter your data and label your columns.
-
2Type the formula into a cell. To learn more about writing formulas, see Type Formulas in Microsoft Excel.
-
3Hover the mouse cursor over the bottom-right corner of the cell. The standard cursor will turn into a crosshair.
-
4Click and drag the crosshair across (or down) the range. This copies the formula to each cell in the range. When you release the mouse button, the formula will run in each cell.
- For example, if you typed a formula in C2 and want to copy it to each cell in the C column through C22, drag the crosshair downward until you’ve reached C22, then release the mouse button.
- You can drag the formula to fill both columns and rows.
About This Article
1. Open your spreadsheet.
2. Type a formula into a cell.
3. Hover the mouse over the cell’s bottom-right corner.
4. Drag the crosshair across (or down) the range.
