Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using Excel 2007. Every time I do a search I have to set the options to search within 'Workbook' and look in 'Values'. Is there a way to permanently set the default search behaviour?

share|improve this question

Excel doesn't allow you to specify what settings you want for a default in the Find dialog box. There is a bit of a way around this seeming limitation, however—at least a partial way. Excel remembers the last settings in the Find dialog box for the entire Excel session. (The settings are not reset until you exit and restart Excel.) This means that all you need to do is create a small macro that will set the settings you want in the dialog box.

See this article for more.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .