XL Search Query

  Dirty Dick 18:25 07 Dec 09

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 09

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

  GaT7 18:33 07 Dec 09

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 09


As usual speedy answer

  Dirty Dick 19:07 07 Dec 09

many thanx also

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

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017