Displaying results in formula bar when cell is hidden

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
 
G

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

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
IF Formula that results in Protection???? 7
Formatting CELLS 2
protect cell format 1
DISPLAYING RESULTS OF A FORMULA 1
Hidden content 4
Formula Bar - display of content 4
Hidden Cell Contents 4

Top