Formula covers the cell

[lezawang]

Hi
Let say I want to write a function in cell A1 and I want to select B1 as an argument to that function. When I start typing the function in A1, the whole function syntax, will cover B1 and I wont be able to select (click) on B1. I watched before a video from ExcelisFun and he showed how to fix that. I do not recall it how and can not find the video. Maybe not ExcelisFun. Thank you.

 

[Michael M]

When you strat typing the formula if you want to refer to B1 simply right arrow to that cell, then continue typing the formula

 

[KRice]

I think you can just hover the mouse cursor near the edge of the popup formula box...and you'll see a cross shaped directional symbol appear. Then just drag the box to a different location.

 

[lezawang]

Thank you. No it is not the box that describe the function is the problem. It is the function itself the problem or lets say if i have nested functions.. then these functions will cover the next cell. The right arrow is now what I remember was the solution. Thank you all for the help.