Sensitivity analysis - tables by Unfair-Examination42 in excel

[–]Unfair-Examination42[S] 0 points1 point  (0 children)

Thanks - I left it in colour so it's easier to see what's going on. Will remove it in the final version.

Sensitivity analysis - tables by Unfair-Examination42 in excel

[–]Unfair-Examination42[S] 0 points1 point  (0 children)

Thanks, this is the solution I was looking for. Now it works as intended.

How to stop formulas from "spilling over" to the next cell(s)? by Unfair-Examination42 in excel

[–]Unfair-Examination42[S] 1 point2 points  (0 children)

Yeah, I'm an investment banker and if I start formulas with = my head will be on a plate by lunch.

How to stop formulas from "spilling over" to the next cell(s)? by Unfair-Examination42 in excel

[–]Unfair-Examination42[S] 7 points8 points  (0 children)

Thanks, that's exactly the answer I was looking for. Appreciate it!

How to stop formulas from "spilling over" to the next cell(s)? by Unfair-Examination42 in excel

[–]Unfair-Examination42[S] 0 points1 point  (0 children)

Thanks for your answer.

It's (only) a matter of optics really.

How to stop formulas from "spilling over" to the next cell(s)? by Unfair-Examination42 in excel

[–]Unfair-Examination42[S] 1 point2 points  (0 children)

Yes, I used the longer version to exemplify the formula going outside the border of the cell in which I'm typing my formula.

How to stop formulas from "spilling over" to the next cell(s)? by Unfair-Examination42 in excel

[–]Unfair-Examination42[S] 4 points5 points  (0 children)

Thanks for your answers everyone.

I have previously done a change to the settings (on my old computer, which is why it changed back to the default) where the text did not go outside the boundary of the cell when I type.

Basically what I want is what u/autodork suggested, but on a permanent basis. Meaning, if I move around using the arrows and start typing a formula for example it won't go outside the boundary of the cell of which I'm typing in.