Search for TRUE in spreadsheet
Is there a way to search for, and warp to, a cell that evaluates to
TRUE? or FALSE? |
Search for TRUE in spreadsheet
Highlight a range of cells (or the whole sheet), then press F5 (GoTo).
Click on the Special button and then select Formulas, and de-select Numbers etc to just leave Logicals. Then click OK. Hope this helps. Pete On Sep 4, 11:38*pm, Paul wrote: Is there a way to search for, and warp to, a cell that evaluates to TRUE? *or FALSE? |
Search for TRUE in spreadsheet
Thanks, Pete.
On Sep 4, 7:30*pm, Pete_UK wrote: Highlight a range of cells (or the whole sheet), then press F5 (GoTo). Click on the Special button and then select Formulas, and de-select Numbers etc to just leave Logicals. Then click OK. On Sep 4, 11:38*pm, Paul wrote: Is there a way to search for, and warp to, a cell that evaluates to TRUE? *or FALSE |
All times are GMT +1. The time now is 07:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com