General discussion

Locked

Copying formulas in excel

By rdl ·
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

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Don Christner In reply to Copying formulas in excel

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

Collapse -

by rdl In reply to

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

Collapse -

by Don Christner In reply to Copying formulas in excel

In Tools-Options-Calculation do you have automatic recalculation selected?

Don

Collapse -

by rdl In reply to

Poster rated this answer.

Collapse -

by bkotnik In reply to Copying formulas in excel

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.

Collapse -

by rdl In reply to

Poster rated this answer.

Collapse -

by rdl In reply to Copying formulas in excel

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Forums