Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Copying formulas in excel

Locked

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

Topic

Reply To: Copying formulas in excel

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

Reply To: Copying formulas in excel

In reply to Reply To: Copying formulas in excel

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

Reply To: Copying formulas in excel

In reply to Copying formulas in excel

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

Don

Reply To: Copying formulas in excel

In reply to Reply To: Copying formulas in excel

Poster rated this answer.

Reply To: Copying formulas in excel

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.

Reply To: Copying formulas in excel

In reply to Reply To: Copying formulas in excel

Poster rated this answer.

Reply To: Copying formulas in excel

In reply to Copying formulas in excel

This question was closed by the author

[Author]

Replies