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.