unhiding formulas

  • Thread starter Thread starter twin617
  • Start date Start date
T

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?
 
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
 
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?
Click to expand...

Check the font color.
 
Back
Top