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

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 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.

• 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.

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

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

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.

Keep Reading:

• How to Count missing values in a list in Excel Office 365?
• Excel Formulas to Highlight the Cells that contains Certain Value!!
• Use Data Validation with No Punctuation in Excel Office 365!!
• Excel Formulas to Highlight the Duplicate Values from Two Columns!!
• How to Wrap Text Manually in Excel Office 365? – {3 Ways}
• Excel Formulas to Apply Conditional Formatting based on Another Column!