Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #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?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 622
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unhiding Frisco, Texas Excel Discussion (Misc queries) 1 November 21st 05 03:14 PM
Unhiding Sheets venita Excel Discussion (Misc queries) 3 July 14th 05 05:01 PM
Hiding/Unhiding Bobby Excel Worksheet Functions 2 May 25th 05 10:40 PM
Unhiding Columns RFJ Excel Discussion (Misc queries) 1 January 21st 05 10:28 AM
Unhiding a sheet Skint4sure Excel Discussion (Misc queries) 3 December 25th 04 10:27 PM


All times are GMT +1. The time now is 08:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"