View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Pedersen David Pedersen is offline
external usenet poster
 
Posts: 4
Default changing default search location in Excel 2007 Find.

When I search for a value in Excel 2007 using the "find" command, I get the
Finda and Replace dialogue box with options to look in values, formulas or
comments. Almost every time, I want to search values. Is there a way to
make this the default value for the "Look in:" list box?