Display of a formula under/above row

Krzysztof Żebruń

Hello

 

In some sheets i have long formulas to grab many intermediate values and eg. sum them in one cell. Problem is when I need to click a cell and this is hidden by formula. Can the formula be displayed under/above a row where I'm typing?

Mike Wilday

This has been a nuisance to me as well. I get around it by scrolling slightly with my mouse wheel - or the side scrollbar...while I am working in the pop-up window. It tends to reveal what  I need. 

Brad Jones

Right on man!  This has been a pain for me for a while.  The workaround was easy enough (press the escape key and then click where I need to), but why not put the formula out of the way?

Another option, put it into a little bar at the top of the browser window.  Then it's not in the way of ANYTHING

J. Craig Williams

My work-around is to select the cell below the one I want and then change the row number manually.

This is also a thorn I would be grateful to see removed.

It would be worse if, you know, I wrote formulas often.

Craig