Microsoft Office Tutorials and References
In Depth Information
The Find and Replace
dialog box disappears.
6
Click in a cell that has
the format you want to
replace.
This example selects
green fills.
The Find and Replace
dialog box reappears.
l
7
6
8
7
A preview of the format
you selected appears.
l
7
Click here and select
Choose Format from cell.
The Find and Replace
dialog box disappears.
9
8
Click in a cell that has the format you want to
use as a replacement.
This example selects a cell with no fill.
The Find and Replace dialog box reappears.
l A preview of the format you selected appears.
9
!
0
Click Replace All.
l Excel replaces the formats.
Excel replaces all of the green fills with plain fills.
0
Click OK.
!
Click Close.
l You can click Replace to make one change at
a time.
l If you want to find instead of replace formats,
click Find All or Find Next to highlight cells in
the worksheet but not replace formats.
Important!
Before you start a new Find
and/or Replace, make sure you
clear all formats by clicking the
down arrow next to the two
Format buttons and then clicking
Clear Find Format and Clear
Replace Format.
Did You Know?
In the Find and Replace dialog
box, clicking a Format button
opens the Find Format or Replace
Format dialog box. You can use
these dialog boxes to specify the
Number, Alignment, Font, Border,
Fill, or Protection you want to
find and/or replace.
Did You Know?
When searching for text or values,
type the text or value you are
looking for in the Find What field.
Type the text or value you want
to replace it with in the Replace
With field.
Chapter 1: Boost Your Efficiency
15
 
Search JabSto ::




Custom Search