If you want to remove a previously specified formatting style from the Find and Replace dialog box, click on the arrow at the side of the For mat.
How to Remove a Formatting Style in Excel Find and Replace Note that if you specify a formatting style and a 'find text' value, the Find command will only find cells that match both the formatting style and the specified 'find text'. This allows you to specify a format that you want to find and (optionally) a Replace format. If the Match Entire Cell C ontents option is checked, the Excel Find command only finds cells for which the entire contents of the cell match the 'find text'.Īlso within the Excel Find and Replace dialog box, you will see the For mat.If the Match Entire Cell C ontents option is not checked (the default option), the Excel Find command finds any instances of the 'find text' that occur in any part of a cell.The Match Entire Cell C ontents option allows a user to request whether the Find command should match any part of a cell's contents or should only match if the 'find text' is equal to an entire cell's contents. If the Match case option is checked, the Excel Find command is case-sensitive.
Then hold Ctrl + H keys to open the Find and Replace dialog, in this dialog, enter the value which you want to find in the Find what text box, and type the. Take the following data for example, I will find the cells which content is tools, and replace them with 2015.