find & select

[Aaron Hodson \(Coversure\)]

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

 

[Duke Carey]

Click the Options button in the Find dialog. Click the Within dropdown and
select Workbook

 

[Aaron Hodson \(Coversure\)]

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

Click the Options button in the Find dialog. Click the Within dropdown
and
select Workbook