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 how do I double check that there are no formulas

Hiding in an excel spreadsheet :o)

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 834
Default how do I double check that there are no formulas

Menu ToolsOptionsView and check the Formulas checkbox. It will show any
formulas then.

--

HTH

Bob

"2468NICKIL" wrote in message
...
Hiding in an excel spreadsheet :o)

Thanks



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 833
Default how do I double check that there are no formulas

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 :o)

Thanks

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
Is there a template to double check Lottery scratcher tickets? lkn4bearbud Excel Discussion (Misc queries) 1 April 18th 09 08:08 AM
Creating fillalbe check boxes in excel by double clicking on chec. Meme Excel Discussion (Misc queries) 0 April 9th 08 09:00 PM
check if there is any double information Art Excel Discussion (Misc queries) 0 December 12th 06 05:52 PM
check for double information Art Excel Worksheet Functions 2 December 11th 06 03:01 PM
Check for double entries in a row Pierrot Robert Excel Worksheet Functions 1 September 5th 05 06:37 PM


All times are GMT +1. The time now is 05:47 PM.

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"