How to Search for a Value in All Tabs in Excel Office 365?
Tags: searchforvalueinallt, excelpreface
Published: 2021-03-22 04:08:56

---
title: How to Search for a Value in All Tabs in Excel Office 365?
published: true
date: 2021-03-20 12:02:18 UTC
tags: Searchforvalueinallt,ExcelPreface
canonical_url: https://geekexcel.com/how-to-search-for-a-value-in-all-tabs-in-excel-office-365/
---

In this article, we will describe the easy steps to **search for a value in all tabs in Excel Office 365** with an example. Here, we are going to use the COUNTIF function to achieve this task with a few steps. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Search for a Value in All Tabs in Excel Workbook:

If you want to search for a value in all tabs in the workbook, follow the below steps.

- Firstly, you have to **[open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/)** where you want to search for a value in all tabs.
- For instance, we are going to search the value **“GeekExcel”** in **Sheet2, Sheet3,** and **Sheet4**.
- In the below example, we have shown in the **value** , **sheets** , and **count**  **columns** with example data.

![Example data](https://geekexcel.com/wp-content/uploads/2021/03/Example-data.png)<figcaption id="caption-attachment-22594">Example data</figcaption>

- Now, you need to **enter the below-given formula**.

**=COUNTIF(Sheetn!1:1048576,Search Value)**

**n –** Corresponding sheet number.

**Search value –** It is the value that you want to search over all tabs.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/03/Enter-the-formula-12.png)<figcaption id="caption-attachment-22595">Enter the formula</figcaption>

- After applying the formula, you need to hit the **Enter** button.
- Now, you will get the result as shown in the below image.

![Hit the Enter key](https://geekexcel.com/wp-content/uploads/2021/03/Hit-the-Enter-key.png)<figcaption id="caption-attachment-22596">Hit the Enter key</figcaption>

- To get the count of the next sheet, you need to apply the formula and get the output.
- Refer to the below image.

![Output](https://geekexcel.com/wp-content/uploads/2021/03/Output.png)<figcaption id="caption-attachment-22597">Output</figcaption>

## Conclusion:

In the above article, we have learned the easy steps to **search for a value in all tabs in Excel Office 365** with an example. Drop your **suggestions/feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)**

**Keep Reading:**

- [How to Count missing values in a list in Excel Office 365?](https://geekexcel.com/how-to-count-missing-values-in-a-list-in-excel-office-365/)
- [Excel Formulas to Highlight the Cells that contains Certain Value!!](https://geekexcel.com/excel-formulas-to-highlight-the-cells-that-contains-certain-value/)
- [Use Data Validation with No Punctuation in Excel Office 365!!](https://geekexcel.com/use-data-validation-with-no-punctuation-in-excel-office-365/)
- [Excel Formulas to Highlight the Duplicate Values from Two Columns!!](https://geekexcel.com/excel-formulas-highlight-duplicate-values-from-two-columns/)
- [How to Wrap Text Manually in Excel Office 365? – {3 Ways}](https://geekexcel.com/how-to-wrap-text-manually-in-excel-office-365-3-ways/)
- [Excel Formulas to Apply Conditional Formatting based on Another Column!](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-based-on-another-column/)