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

protect cell format 1
Fit Row Height for Cell with Text from Formula 0
Formatting CELLS 2
Copy formula from above cell in protected worksheet 0
DISPLAYING RESULTS OF A FORMULA 1
the forumula bar is not visible 2
Cell in new sheet should always refer to defined cell in another s 8
Formula Bar - display of content 6

Top