Forum Discussion
lanszelot
May 27, 2024Copper Contributor
Excel add same formula easy way
Hello, I have numbers in C1 till Z1 cells. I would like to multiply these cells value with A1 value. Example: +A1*C1, +A1*B1......+A1*Z1 I know I could write one by one. But is there a simple w...
SergeiBaklan
May 27, 2024Diamond Contributor
As variant =C1*$A$1 in C2, select C2:Z2, Ctrl+R