View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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?