Displaying results in formula bar when cell is hidden

  • Thread starter Thread starter andy62
  • Start date Start date
A

andy62

Is there any way to have the results of a formula appear in the formula bar
when the cell is protected and hidden, and sheet protected? I have formulae
that retrieve text, but the cells are not wide enough to display all that
text, and the formula bar shows nothing (blank) when the cell is protected
and hidden, and the sheet is protected. I think my alternative is how excel
should work . . .

TIA

Andy
 
By setting the cell properties to hidden, you hide the data in the formula
bar, not in the cell.

That's what "hidden" on a protected sheet means.

Suggest you unprotect the sheet and uncheck "hidden" or widen the columns or
allow formatting of rows and set the cells to wrap text and row autofit.


Gord Dibben MS Excel MVP
 
Back
Top