– How to Find a Text String with Case Sensitive
– How to Find a Text String that Matches the Entire Cell Contents
– How to Find a Text String that Matches Entire Cell with Case Sensitive
When working with Excel, especially a large file, you might need to search for a text string. Please follow the steps below to check details:
Step 1: Click anywhere in the worksheet;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click "Find & Select", and select "Find" from the drop-down list;
Alternatively, please use shortcut Ctrl+F to bring up "Find and Replace" window.
Step 4: In the "Find and Replace" window, type the text string (or any letter or number you want to find in the worksheet);
Step 5: Click "Find Next" at the bottom; to find all the cells contain the text string (or number), please click "Find All".