unhiding formulas

[twin617]

I have a column with 5 rows and the formula is invisible except for the
toolbar but I forgot how I hide that. Under the protect tab it is unchecked
for hidden or locked. How can I unhide my formula?

 

[Max]

On the face of it ...
1. Click View > Formula bar (to re-instate the formula bar)
2. Unprotect the sheet, then select then entire sheet. Then click Format >
Cells > Protection tab > Uncheck "Hidden" > OK. Then re-protect. Your
formulas should be visible now.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik

 

[Jan Bolluyt]

Hit the control and Tilde key

Hope this helps

JB

 

[Spiky]

I have a column with 5 rows and the formula is invisible except for the
toolbar but I forgot how I hide that. Under the protect tab it is unchecked
for hidden or locked. How can I unhide my formula?

Check the font color.