Thread: find & select
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aaron Hodson \(Coversure\) Aaron Hodson \(Coversure\) is offline
external usenet poster
 
Posts: 46
Default find & select

Of course it is, sorry, had a "special" moment!

"Duke Carey" wrote in message
...
Click the Options button in the Find dialog. Click the Within dropdown
and
select Workbook

"Aaron Hodson (Coversure)" wrote:

I have a number of PCs which are running on XP office software.

After using a machine running Office 2007, I was impressed with the find
and
select facility which searchs the whole workbook (not just sheet).

Can office XP perform this?? The 'ctrl F' function only seems to search
the
current worksheet and it would be of great benefit to have a facility
like
this on my XP machines (is there a formula, some sort of vlookup) as it
takes a long while to go through all worksheets doing the same search.

Thanks

Aaron