Formula Bar Blocking Boxes

Bob Lee

I'm sure this is an easy one, but when I'm adding a bunch of math in a specific field, it eventually blocks the entire row. I then can't choose boxes within the row that will be nested in the equation. 

 

Any way to hide the formula or make it so I can still see/click the boxes behind it?

 

Thanks!

J. Craig Williams

Here's what I do to work-around this:

 

I select the row above or below the column I want to select and then manually edit the row number.

 

I feel your pain.

 

Craig

 

Emir Okyayli

This is what I would do: say you want your equation in cell G:5, instead type the equation into C:4 (or wherever, just somewhere else where the formula bar wont block other cells), when you are finished, drag cell C:4 onto G:5.

 

I hope this makes sense.

 

Emir

k.mcnamara23941

Its a total pain in the ...... and very frustrating when you come from a high level excel user to something that's a long way behind.