Using the Advanced Find & Replace feature
Normal “find and replace” is great most of the time, but sometimes you need to find something in a more complicated scenario. There are a few advanced options in Excel to use with find and replace that can help.
For this, you need to click on the “Options” button in the find and replace dialogue box. From here you will be able to refine your search better.
Within: You can select the search area for the value. You can select between the active worksheet and the whole workbook.
Search: Search through rows or columns.
Look in: Look in formulas, values, comments, and notes (This option only works with find, not with find and replace).
Match Case: Find and replace a value with a case-sensitive search.
Match Entire Content: Match values from the entire value of a cell with the searched value.
Format: With this option, you can search for a cell based on its formatting. You can specify the formatting, or you can use a selection tool to select it from a cell.
Interested in learning more great features in excel that can save you time and remove frustration? Click here to visit our website or contact our team to discuss a tailored session on 02 6215 9710 or courses@ausmanagement.com.au.