Copying % formula

revenue - Apr 6, 2010 at 09:38 AM
 revenue - Apr 6, 2010 at 10:57 AM
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.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 6, 2010 at 09:58 AM
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