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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…