Forum Discussion
tplant23
Jan 13, 2024Copper Contributor
copy a formula
I am trying to copy a forumal that needs to maintain the original cell. I am trying to do a budget where the annual total is X and then have the 12 months extended. The first formula would be for instance =d3/12. I then need to copy that formula for the remaining 11 months with d3 being in each cell.
- PeterBartholomew1Silver Contributor
- tplant23Copper ContributorThanks, how do I make this go horizontal instead of verticlal?
- PeterBartholomew1Silver Contributor
Place a comma before the 12 in SEQUENCE. The first parameter is the number of rows and the second the number of columns.