unhiding formulas
 

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?

unhiding formulas
 

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
---
"twin617" wrote:
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?

unhiding formulas
 

Hit the control and Tilde key

Hope this helps

JB
"twin617" wrote in message
...
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?

unhiding formulas
 

On Jul 22, 10:48 pm, twin617
wrote:
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.