Finding and Replacing Cell Formatting

The Find and Replace commands make it easy to locate or replace specific text, numbers, and formatting in a workbook. For example, you might want to replace all the references to cell A6 in your formulas with data contained in cell H2, or you might want to replace bold text with italic text. Or, you may want to change a client name or contact on all of your financial reports. You can be specific in your replacing, by replacing one at a time, or all matches found.

Find or Replace Cell Formatting

Image Click the Home tab.

Click the Find & Select button, and then click Find or Replace.

If you want, enter the word ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.