Formula Bar Blocking Boxes

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!

Find more posts tagged with

Formulas

Comments

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.