Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unhiding | Excel Discussion (Misc queries) | |||
Unhiding Sheets | Excel Discussion (Misc queries) | |||
Hiding/Unhiding | Excel Worksheet Functions | |||
Unhiding Columns | Excel Discussion (Misc queries) | |||
Unhiding a sheet | Excel Discussion (Misc queries) |