Previous in Forum: How to Protect My WD External USB2 HDD?   Next in Forum: OCZ "Vertex Series" SATA II 2.5" Solid State Drive
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
6 comments
Rate Comments: Nested
daffy
Power-User

Join Date: May 2008
Posts: 306
Good Answers: 12

Excell 97 Help - Paper Clip no Help

05/04/2011 9:46 PM

Hi again... This time I have an Excell 97 question where the Help Paper Clip is no help...I want to do a search (find) a string of characters or a part number within my spreadsheet that has some 20+ sheets. The Ctrl F only searches the active sheet. I found a shorter way (using Sft-F4) and opening every sheet. There does not seem to be a find method across multiple sheets. I tried highlighting the sheets and doing a search - yes it jumps to one sheet but as I try hit enter to find other instances, it remains on the one sheet. Thanks in advance.
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
jack of all trades
Guru
New Zealand - Member - Kiwi Popular Science - Weaponology - New Member Engineering Fields - Power Engineering - New Member Engineering Fields - Electrical Engineering - New Member

Join Date: Sep 2006
Location: Auckland, New Zealand
Posts: 8777
Good Answers: 376
#1

Re: Excell 97 Help - Paper Clip no Help

05/04/2011 10:44 PM

Well under Excel 2003 you can perform a search using ctrl F, expand the 'options' box and choose the 'within' box and set it to 'workbook' which will search all sheets in an open workbook.

Excel 97 should work the same (hopefully).

__________________
 jack of all trades
Register to Reply
daffy
Power-User

Join Date: May 2008
Posts: 306
Good Answers: 12
#2

Re: Excell 97 Help - Paper Clip no Help

05/05/2011 12:03 AM

No...97 does not have this. Ctrl F only has Search by row/column and Look in Formulas/values/comments...and two tick boxes: match case and find entire cells only.
Register to Reply
TrevorM
Power-User

Join Date: Jun 2009
Location: Australia
Posts: 277
Good Answers: 45
#3

Re: Excel 97 Help - Paper Clip no Help

05/06/2011 12:10 AM

You could always write a macro and do it that way. My code writing skills are not current enough to give you the detail, but if you learn by recording a couple of macro's and by reading web pages that relate to something like "Excel Macro searching multiple sheets for values" you should manage to generate a solution in a few hours.
Register to Reply
Gabriel
Commentator

Join Date: Oct 2006
Location: Buenos Aires, Argentina
Posts: 89
#4

Re: Excell 97 Help - Paper Clip no Help

05/06/2011 8:27 AM

Hi: you can do "CTRL+ Click" in each sheet you want to search and then "CTRL+F".

Gabriel

__________________
 Gabriel, Buenos Aires, Argentina
Register to Reply Score 1 for Good Answer
No more "Almost" Good Answers.
cb50chevy
Active Contributor

Join Date: Apr 2010
Location: Wisconsin
Posts: 13
#5

Re: Excell 97 Help - Paper Clip no Help

05/06/2011 8:32 AM

I have found this website very helpful with all excel questions. www.ozgrid.com They have experts that will help when you post questions just like CR4 does only it deals exclusively with excel problems.
Register to Reply
robbump
Commentator

Join Date: Aug 2010
Location: Schenectady NY
Posts: 57
Good Answers: 2
#6

Re: Excell 97 Help - Paper Clip no Help

05/06/2011 10:23 PM

The oldest version I have to test against is Excel2000 -- and here's how I was able to do a search across multiple sheets:

Before you start your search:

  • click on the first sheet (the tabs along the bottom)
  • hold down SHIFT and click on the last sheet

Now start your search. (You instead could hold the Ctrl key and click on each sheet that you wish to search through instead before your search)

Definitely worked in Excel 2000 and did jump from sheet to sheet.
Register to Reply
Register to Reply
Have a Different Question?
6 comments

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Copy to Clipboard

Users who posted comments:

cb50chevy (1); daffy (1); Gabriel (1); jack of all trades (1); robbump (1); TrevorM (1)

Previous in Forum: How to Protect My WD External USB2 HDD?   Next in Forum: OCZ "Vertex Series" SATA II 2.5" Solid State Drive

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (54 right now)
Show Members
Advertisement