Long Formula Covers Column Headers [SOLVED]

[mrhartley]

Hi,

I was wondering if this bothers others and if anyone had a suitable idea to get round it.

I have a workbook where some cells have very long forumula in them.

In the forumula bar, the formula is word wrapped thus taking up three rows of text (hope that makes sense) and as a result, the column headers only being 1 row below the formula bar becomes obscured by the formula text.

Assuming anyone can picture what I am trying to describe, has anyone found a way around this annoying problem.

Cheers
~Mark

 

[Richard Schollar]

Hi Mark

Yep annoys me too - the easiest solution I found was to go Windows>Arrange and make sure there was sufficient space between the formula bar and my worksheet to accommodate the formula. Bit of a pain in the bum though - would be nice to have an option to restrict the formula bar display. I'd be ineterested to hear if others have alternative solutions.

Best regards

Richard

 

[mrhartley]

Thanks Richard,

I forgot to mention that your workaround did the trick well enough

TY
~Mark