LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Find and Replace - Options

Is there a way, in Excel 2003, to change the default Find and Replace options
to look for Values rather than Formulas in the Look In field? The data we
are searching is 90% values and we have to reset the Option time Excel is
restarted. We have some inexperienced users who forget to change the Options
and we do not catch all data.

Thanks
 
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
Find and Replace - Replace with Blank Space Studebaker Excel Discussion (Misc queries) 4 April 3rd 23 10:55 AM
Excel 2003/edit/replace. Under Options/Look In, values is AWOL bu. cp Excel Discussion (Misc queries) 2 March 15th 13 12:07 PM
where to put results of find operation in find and replace functio DEP Excel Worksheet Functions 5 November 15th 06 07:52 PM
find and replace - replace data in rows to separated by commas msdker Excel Worksheet Functions 1 April 15th 06 01:00 AM
Change Excel Find & Replace Options Defaults Rocky Lane Excel Discussion (Misc queries) 1 March 29th 06 03:39 PM


All times are GMT +1. The time now is 02:59 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"