find & select
 

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

find & select
 

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

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