Displaying results in formula bar when cell is hidden



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 . . .





Gord Dibben

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question