[Solved] Search for name in multiple sheets

[timlab55]

I have a shreadsheet. In this shreadsheet, I have 5 tabs on the bottom. Each tab has about 300 names in each tab. So what I'm wondering is there away to bring up a search box, search each tab for a name. For example: I'm looking for the name of tim or Tim or TIM. How can I have open office search each tab until it reaches that name?

Edit: Changed subject, was Searches  Make your post understandable by others  -- MrProgrammer, forum moderator

[Hagar Delest]

Find All then All sheets? (at least in LibreOffice).
In the Find and replace dialog.

Fin_all.png (13.59 KiB) Viewed 2547 times

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the ✎ button if your issue has been fixed.

[RoryOF]

In OpenOffice, in Find and Replace in Calc, on the More Options dropdown at very bottom is a checkbox to "Search in all sheets".

[DiGro]

Don't forget to click "More options" first, otherwise you won't see it

AOO_search_all_tabs.png (16.69 KiB) Viewed 2494 times