I have been trying to make some formulas in my spreadsheets and then copy-pasting the cell into several cells in the column, e.g. to add more years to the model.
I have a single cell , say A1 which is the rate of return.
In the sheet I would have a cell B2 asset value and cell C2 new value with a formula like =B2+(B2*A1).
When I copy-paste the cell into cell C3, I end up with =B3+(B3*A2), when what I really want is =B3+(B3*A1).
Is there some way to designate a cell to not "auto-increment" during copy paste?
So far the best I could come up with is to make an entire column for inflation rate and to just repeat the constant number.
Thanks.
Joe
I have a single cell , say A1 which is the rate of return.
In the sheet I would have a cell B2 asset value and cell C2 new value with a formula like =B2+(B2*A1).
When I copy-paste the cell into cell C3, I end up with =B3+(B3*A2), when what I really want is =B3+(B3*A1).
Is there some way to designate a cell to not "auto-increment" during copy paste?
So far the best I could come up with is to make an entire column for inflation rate and to just repeat the constant number.
Thanks.
Joe