Find and Replace Tool

If you work in the type of office where you can’t install your own favourite productivity software due to strict IT policies, then it’s likely that Microsoft Office is already installed on your system. Microsoft Office is packed with features that can help you stay on top of things and get the job done.

Here is a useful tip:

Make Good Use of the Find and Replace Tool

Many of us are aware that we can use Find and Replace to search for text within our workbook or spreadsheet.

To do this you click the Find & Select tool (it’s a picture of a pair of binoculars) on the HOME tab. The keyboard shortcut is CTRL+F. Once you’ve done that then just fill out the “Find what:” field as necessary.

It works very well. However, what if you’d like to find something that’s written as part of a comment somewhere in the spreadsheet? In that case the default settings won’t work.

However, notice the button near the bottom-right that’s labelled “Options>>”


Click on that and you can select a couple of different places to find items in; formulas, values, or comments.


If you choose to look in comments then Excel will do that for you, and when it finds the text you’re searching for it will identify the cell that comment belongs to. You can then edit or delete the associated comment as desired.

Our JN Software training courses are designed to help you unleash the power of whichever applications you need to use. We can provide the training to enable you to maximize your efficiency with Excel, Word, or any other parts of the Microsoft Office suite.

Posted in Excel, MS Office, Newsletters and tagged , , , , , , , .