If you need to find comments, search throughout your Excel spreadsheet, or make your searches case sensitive, watch Excel Video 269. We’ll start on the options available in the Find and Replace window today. You’ll see how to search across an entire workbook instead of just one sheet and how to control which direction Excel searches. We’ll also work through an example of searching in comments.
By default, Excel’s searches aren’t case sensitive and the search function looks any place in the cell. If you need your search to be case sensitive or you need to exactly match what’s in the cell, you’re in the right place. We’ll work through an example of both options today.
Stay tuned, there are a couple more find and replace tricks you’ll find helpful. We’ll work through those tricks in the next Excel Video.
