Copying % formula

Solved/Closed
Report
-
 revenue -
Hi, I regularly calculate a series of number as a percentage of a sum that remains constant (expense item as a percentage of total expenses, for eg.) How can I copy the formula and keep the constant (eg total revenue). When I drag down, the cell number in that position in the formula lowers with the destination cell number. (Hope that is clear.) Right now I enter the formula for each cell I am calculating which is a pain. I am using Excel for Mac.
Elizabeth

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
To keep address of a cell constant you need to use $

$A$1 is absolute to A1 always

$A1 is absolute column A but row will change

A$1 is absolute row 1, but column would change
Thank-you!