Excel - Find

  swapper 07:14 10 Oct 2006
Locked

With excel 2000, can I use "Find" or "Replace" (in edit) to seek an item in more than one sheet at a time, or must I go to each sheet in turn to change the same item?
tia

  rmcqua 08:16 10 Oct 2006

If you tick "within workbook" in the Edit > Find > within box, it will serach through the whole document and display each sheet where a match is found.

  swapper 09:21 11 Oct 2006

rmcqua, thank you for responding, I looked again in Edit-Find, but I have only a couple of options.

Search- by rows, by columns.
Look in - Formulas, Values, Comments.
Find Next, Close, Replace.
My version of excel is 9.0.2720

  GroupFC 11:01 11 Oct 2006

I suspect that rmcqua's suggestion may be a refinement in later version of Excel, or may have been added with another add-in, as I can't find in mine either (excel 2000)!

  GroupFC 11:03 11 Oct 2006

I have just done a search "using find in entire workbook in excel" and sure enough the scond hit says "New and Changed Features in Excel 2003. ... You can now search the entire workbook using Find and Replace." (see click here=)

  swapper 06:53 12 Oct 2006

GroupFC, rmcqua,

Thanks for the info, thats that then, I cannot afford to update to 2003. :-(((

  Cesar 09:01 14 Oct 2006

Bump

  swapper 19:14 14 Oct 2006

As my original question has been answered (thanks). I think this is resolved, and I will start a new thread about buying excel 2003

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Converse draws on iconic heritage for a fresh brand identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans ├ęchec ?