ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I double check that there are no formulas (https://www.excelbanter.com/excel-worksheet-functions/262514-how-do-i-double-check-there-no-formulas.html)

2468NICKIL

how do I double check that there are no formulas
 
Hiding in an excel spreadsheet :o)

Thanks

Bob Phillips[_4_]

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




trip_to_tokyo[_3_]

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



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com