| Edit: Changed subject, was Searches Make your post understandable by others -- MrProgrammer, forum moderator |
[Solved] Search for name in multiple sheets
[Solved] Search for name in multiple sheets
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?
Last edited by MrProgrammer on Tue Apr 01, 2025 3:22 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
OpenOffice 4.1.14 on Windows 11 Pro
- Hagar Delest
- Moderator
- Posts: 33629
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Search for name in multiple sheets
Find All then All sheets? (at least in LibreOffice).
In the Find and replace dialog.
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.
In the Find and replace dialog.
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.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
Re: Search for name in multiple sheets
In OpenOffice, in Find and Replace in Calc, on the More Options dropdown at very bottom is a checkbox to "Search in all sheets".
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
Re: Search for name in multiple sheets
Don't forget to click "More options" first, otherwise you won't see it
____________
DiGro
AOO 4.1.16 (Dutch) on Windows 11 64-bit. Scanned with Ziggo Safe Online (F-Secure)
DiGro
AOO 4.1.16 (Dutch) on Windows 11 64-bit. Scanned with Ziggo Safe Online (F-Secure)