I'm facing a small, basic little problem, for which I can't find the solution: I'd like to insert the same formula in several cells at once. Quickly googling this problem provides a solution: Either highlighting all cells and use ctrl+enter, or using the fill tool. But all of these solutions change the formula accordingly. (e.g. if I use =P1/12, and select all cells from B1 to O1, P1 decrements) The cell should not be treated as a variable.

Basically, I just want to type in a number (e.g. expenses) for one year, that gets split up in 12 equal numbers for each month, hence P1/12.


Use $ in front of each part of the cell to keep it static.
For example: =$P$1/12

  • 2
    $ is what keeps a reference absolute, $A$1, A$1 and $A1 are all acceptable uses – cybernetic.nomad Oct 18 '18 at 19:57
  • @cybernetic.nomad Thanks for the additional information – user51497 Oct 18 '18 at 22:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.