Software

Ask something
Discussion Locked

Copying formulas in excel

0 helpful
7 replies

by rdl

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to copy a formula from 1 cell to the rest of the cells in the same column, but it's copying the results, not applying the formula. How can I change this. Thanks

7 replies

by don christner

Select the cell with the formula. Notice the small black square in the lower-right corner of the cell? Float your mouse over that box (your mouse pointer will change to a +). Hold the left button of your mouse down and drag down the column.

Don

by rdl

I've done that several times, however, it's copying the Value of the cell, not applying the formula.

by bkotnik

When you go to paste it to another cell, select past special, select formula. This has worked for me in the past.

I hope this helps.

This discussion is closed to new replies.