BleepingComputer.com: Microsoft Excel 2007

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Microsoft Excel 2007 Searching the workbook

#1 User is offline   Beenthere 

  • Member
  • PipPip
  • Find Topics
  • Group: Members
  • Posts: 111
  • Joined: 29-March 08

Posted 25 June 2010 - 03:00 AM

Hello

So I have this excel document with many sheets. Whenever I do a search I want it to search the entire workbook. However the default search is always set on: sheet. How can I make it so that the default search whenever I open excel is: workbook?

#2 User is offline   Budapest 

  • Bleepin' Cynic
  • PipPipPipPipPipPip
  • Find Topics
  • Group: Moderator
  • Posts: 22,235
  • Joined: 11-November 06
  • Gender:Male

Posted 27 June 2010 - 06:51 AM

I have not tested this myself but it looks promising:

http://excel.tips.net/Pages/T008801_Changi...h_Settings.html
The power of accurate observation is commonly called cynicism by those who haven't got it.

—George Bernard Shaw

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users