Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday. Type the cell or range address into the Name box (located to the left of the Formula bar) and press Enter.
Ĭheck out the Microsoft Excel archive and catch up on other Excel tips. Double-click the fill handle (the small black square in the lower-right corner of the cell. To ensure that you copied the formula correctly, click in C1 and then press. Follow these steps for foolproof cell copying: Click in C2 and enter B2300. Double-click the fill handle (the small black square in the lower-right corner of the cell).Įxcel will stop copying the formula when it reaches a row with a blank cell in Column B.Follow these steps for foolproof cell copying: Selecting 100 cells is a time-consuming and error-prone process, but you can copy the formula down Column C without having to select the cells. You would like to enter a formula that calculates the retail price for each product and displays the results in Column C. These methods are fine for copying formulas down a column of cells - unless the column extends down hundreds of rows.įor example, say Column A in your worksheet lists 100 products and Column B lists the wholesale price of each. You can use Excel’s Auto Fill feature or, as an alternative, select the cells you want to copy to, enter the formula in the active cell, and then press.
Here's a foolproof little trick that will knock out the task for you.Įxcel provides a number of ways to copy formulas. Copy hundreds of rows of Excel formulas in three stepsĬopying formulas in Excel is a relatively simple operation - unless you need to copy down through dozens or even hundreds of cells.