In this article:

How to Search All Tabs in Google Sheets (Easiest Way in 2024)

December 5, 2024
steps to search all tabs in google sheets

Search All Tabs in Google Sheets

Follow the steps below to search all tabs in google sheets. 


1. Open the Search Bar with Ctrl + F

To search across all tabs, start by opening the search function. In Google Sheets, you can do this by pressing Ctrl + F on your keyboard. This will open a small search bar at the top right corner of your screen.

search multiple tabs in google sheets

2. Click the Three Dots for More Search Options

The default search function only searches the current tab. To search all tabs, click on the three dots (more options) in the search bar. This will open advanced search options where you can change the search settings.

how to search all tabs on google sheets

3. Choose “All Sheets” from the Search Settings

Within the advanced search options, you will see a setting called “Search in”. Click on this dropdown menu and select “All sheets.” Click done to save settings.

searching all tabs google sheets

4. Type Your Search Term to Find Across Tabs

Now, click CTRL + F again and type in the keyword or phrase you want to find across all tabs in your spreadsheet. Google Sheets will automatically highlight every instance of your search term throughout all the tabs, making it easy for you to locate the information.

google sheets how to search all tabs

5. Use Arrows to Navigate Through Results

You can move between search results by clicking the arrows next to the search bar. This will take you through each instance of your search term, jumping between tabs if necessary. Use this to quickly find and review all relevant information in your spreadsheet.

search all tabs in sheets‍

6. Close the Search Bar When Done

Once you’ve found what you’re looking for, close the search bar by clicking the “X” on the search bar or pressing Esc on your keyboard. This will exit the search mode and return you to your normal view.

search all tabs shortcut google sheets


We hope that you now have a better understanding of how you can search all tabs in Google Sheets. If you enjoyed this article, you might also like our articles on how to show hidden sheets in google sheets and how to linearize a graph in google sheets

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->