Find value in a range, worksheet or workbook

Search and replace in all or selected workbooksīelow you will find an overview of the Excel Find capabilities as well as the detailed steps on how to use this feature in Microsoft Excel 365, 2019, 2016, 2013, 2010 and older versions.How to change cell formatting on the sheet.Replace text or numbers in a range or in the entire sheet.Select and highlight all found entries on a sheet.Find values in a range, worksheet or workbook.Scanning through hundreds of rows and columns is certainly not the way to go, so let's have a closer look at what the Excel Find and Replace functionality has to offer. When working with big spreadsheets in Excel, it's crucial to be able to quickly find the information you want at any particular moment.

We will also explore the advanced features of Excel search such as wildcards, finding cells with formulas or specific formatting, find and replace in all open workbooks and more. In this tutorial, you will learn how to use Find and Replace in Excel to search for specific data in a worksheet or workbook, and what you can do with those cells after finding them.