PC Review


Reply
Thread Tools Rate Thread

how do I double check that there are no formulas

 
 
2468NICKIL
Guest
Posts: n/a
 
      27th Apr 2010
Hiding in an excel spreadsheet )

Thanks
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      27th Apr 2010
Menu Tools>Options>View and check the Formulas checkbox. It will show any
formulas then.

--

HTH

Bob

"2468NICKIL" <(E-Mail Removed)> wrote in message
news:FE886FD6-BCAD-4589-B7AD-(E-Mail Removed)...
> Hiding in an excel spreadsheet )
>
> Thanks



 
Reply With Quote
 
trip_to_tokyo
Guest
Posts: n/a
 
      27th Apr 2010
EXCEL 2007

Try the following:-

F5 / Special . . . / click in Formulas / OK / should return:-

No cells were found

If my comments have helped please hit Yes.

Thanks.



"2468NICKIL" wrote:

> Hiding in an excel spreadsheet )
>
> Thanks

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Double Negative in formulas Rick Microsoft Excel Misc 0 12th Sep 2008 02:15 AM
Check for double entries in a row Pierrot Robert Microsoft Excel Worksheet Functions 1 5th Sep 2005 06:37 PM
A double check, please Stuart Microsoft Excel Programming 9 21st Apr 2005 11:06 PM
double dash in formulas -- =?Utf-8?B?VGVkIE1ldHJv?= Microsoft Excel Misc 4 29th Dec 2004 04:19 PM
some 'sum' formulas when double clicked to check range zero out - formula still there adam hayes Microsoft Excel Discussion 2 15th Jul 2004 12:35 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:46 PM.