How do I specify in excel that the formula = A1 * A4 will always multiply a cell by A4 even when pasted into another cell?


Rate This Answer

A4 Use the "$" sign before each part of the cell reference that you do not want to change when you copy and paste it. Thanks!

Answered -

Comments

Advertisement