Find in 2007 Excel

[milnerman]

I don't know how to ask this so I will explain it. Across the bottom of the spreadsheet there are sheet 1, sheet 2, etc .... If I am on the first sheet and I want to find a number on another sheet. Is there anyway I can use the find function to find it in another sheet. As of now I can only find that number if I use the find on the sheet it is on.

Blessings!
Richard

[Ron Coderre]

Try this...
• Home.Find_&_Select
...Find what: (enter the search item here...e.g. Done)
...Click: Options button
......Within: Workbook
...Click: Find Next

Does that help?