Ask Your Question

Search every tab or page in spreadsheet (Calc)

asked 2018-08-05 04:02:43 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

The Edit>Find and Edit>Find-and-Replace functions seem only to work on the tab or page which is in view. Is there a way to search every tab or page in a spreadsheet at one go, without having to repeat the search on each tab/page? (I tried "find-all" and it seems to work no differently from "find".)

I am using version LibreOffice on a Mac.

Thank you.

edit retag flag offensive close merge delete


Your question is about sheets.
Please don't use the term 'tab' for the sheet. The tab is an object of its own (can be coloured e.g.).

Lupp gravatar imageLupp ( 2018-08-05 14:47:06 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-08-05 07:20:11 +0200

JohnSUN gravatar image

Are you looking for the "All Sheet" checkbox? It's located under the Find field

Search every tab

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-05 04:02:43 +0200

Seen: 29 times

Last updated: Aug 05 '18