my calc spreadsheet has multiple tabs. I’m using the Find function to search for a text throughout the whole spreadsheet. However, in the Find Toolbar, the default value to search is only in the current tab you are in. In Excel, there is an Advanced filter where you can select if you want to search the whole spreadsheet.
So far in Calc, I have only found that feature when i click on Find & Replace. Thats when the pop up comes & you’re able to select the whole spreadsheet.
Is there any other way to have that functionality?
The Calc is not an Excel clone. There are same, similar, and different features.
1 Like
Select more than one Sheet before (by CTRL-Click on the TAB of the Sheet), and then use the Find All button.
1 Like