XL Search Query

  Dirty Dick 18:25 07 Dec 2009

I am running Vista and XL 2007. I have a workbook, with 80 sheets. I am using it to store text for a language course.

I know how to search ONE worksheer, but is ther any way of searching the FULL workbook.

Thanx (Gracias)


  VoG II 18:33 07 Dec 2009

In the Search dialog click the Options button then select Workbook on the Within: dropdown.

  GaT7 18:33 07 Dec 2009

Right-click on a worksheet tab & choose 'Select all Sheets. Then do a search as normal - it will now search in the entire workbook. G

  Dirty Dick 18:33 07 Dec 2009


As usual speedy answer

  Dirty Dick 19:07 07 Dec 2009

many thanx also

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017