Microsoft Office Tutorials and References
In Depth Information
Finding and Replacing Cell Formatting
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
Click the Home tab.
Click the Find & Select button, and then click Find or Replace .
If you want, enter the word or words you want to find.
Click Options to display formatting options. If necessary, click Format , and
then click Clear Formatting From Cell to clear previous criteria.
Click Format .
Specify the formatting you want to locate, and then click OK .
Search JabSto ::




Custom Search